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

  • rpc.statd goes wild!

    I came in to work today to find my mac workstation spinning running rpc.statd at 100% CPU. A quick dtruss -n rpc.statc showed that it was looping…

  • Useful Javascript

    I just created a drop-down menu with an option to add your own entries. Feel free to use. The skinny. Demo.

  • (no subject)

    I just asked my OpenSRS/Tucows domain reseller rep about AAAA (IPv6) glue records: They are planning to support them soon! In the mean time, they…

  • 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