Aria Stewart (aredridel) wrote,
Aria Stewart
aredridel

MS SQL vs PostgreSQL Round 1

Time to install server and all updates: MSSQL, 4 hours. PostgreSQL, 10 minutes.

Time to create first database: MSSQL, 10 minutes, PostgreSQL, 10 seconds.

Time to connect to first database: MSSQL, 1 hour, PostgreSQL, 10 seconds.

Time spent adjusting firewall rules: MSSQL, 30 minutes. PostgreSQL, 5 minutes.

Time spent figuring out how to read the middle part of a merged field separated with a delimiter: MSSQL, 4 hours. PostgreSQL, 1 minute.

Time to restart service after configuration changes: MSSQL, 1 minute, PostgreSQL, 1 second.

Ease of finding documentation: MSSQL, as terrible as trying to read a book online without hyperlinks, PostgreSQL, well-made online documentation with an interactive updates section.

Score: MSSQL, 0, PostgreSQL, 7. Looks like a win for open source.

Subscribe

  • (no subject)

    You do occasionally visit Boston Public Library, yes? If not, get on it! You were raised in and on libraries. They are in your blood! You…

  • (no subject)

    "I had never been in a room of people who were going to say 'yes' to me before." My friend and I crammed into a rush hour crowded train…

  • Recipe: Storm in the Garden

    Recipe: Storm in the Garden Ingredients 10 ml lavender vodka 10 ml orange vodka 10 ml hibiscus vodka 200 ml ginger ale ice…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 6 comments