Freigeben über

Running PostgreSQL and MySQL on Windows

  • Artikel

Looking to run a database (maybe to learn SQL or to host your recipe collection)?  SQL Server 2005 certainly fits the bill (and there is a free edition here), but if you want to try some of the other options available on the interweb, the two following guides from the Port 25 TechNet team will get you up and running:

PostgreSQL on Windows: A Primer

This paper will cover the installation and initial configuration of PostgreSQL 8.2 on Windows up to a point where a database is created and plpgsql is installed in it. We assume an ability to walk through the install wizard in general, though screens that do require additional information will be covered (with screenshots). Important options in the postgresql.conf and pg_hba.conf will be covered, as will database creation in PgAdmin III.

MySQL on Windows: Configuration & Install

This week, the lab looks at configuring and installing MySQL - an open source relational database management system which is typically used for web applications.

This paper will provide an overview of configuring & installing this software on Windows. MySQL does not have as many features as PostgreSQL , however, and one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL uses a process-based architecture instead).
Note: This paper represents testing and documentation in a lab environment. User Account Control (UAC) is an essential security component to Windows and Microsoft does not recommend turning off UAC in production environments.

Comments

  • Anonymous
    June 10, 2015
    US home solar power system capacity increase of 76% over last year, to 437 megawatts (MW) ,Solar Batterieshttp://www.poweroak.net the nation's new generating capacity, more than half of which is a photovoltaic power generation. The report shows that a quarter of the US solar power capacity by 1.3 gigawatts (GW), the sixth consecutive quarterly increase of over 1 GW. The total annual installed capacity is expected to reach 7.9 GW, Solar Power Peneratorhttp://www.poweroak.net , Solar Power Pack http://www.poweroak.net representing an increase of 27%.
    The report predicts that by 2016 solar power will meet the electricity needs of about 800 million households in the United States to offset 45 million metric tons of carbon emissions, equivalent to removing 10 million cars. energy storage systemhttp://www.poweroak.net/energy-storage-system-c-1.html