×

SparkFun Electronics will be closed on July 3rd, 2015 in observance of Independence Day. Any orders placed after 2:00pm MT on July 2nd will be shipped out after the weekend. Thanks!

Member #203540

Member Since: February 15, 2011

Country: United States

  • Stored procedures in postgres can be a very good solution for gaining tons of performance because postgres has a bit more transaction overhead than a dumb database like mysql. Using a stored procedure gets around this by putting a bunch of work into a single transaction.

    I disagree that it makes things less portable, it just makes things less portable to a database that doesn’t also have a decent procedure language. If you were to port this data to oracle or even mssql, you simply write a proc in that database to produce the same data and press on.

    The point is that moving from mysql to postgres isn’t super difficult (though it is time consuming), but moving from postgres back to mysql is pretty much impossible.