These are some random new PostgreSQL features that I'm interested in: The EXECUTE USING feature in PostgreSQL 8.4 will allow the use of more secure dynamic SQL in PL/PgSQL.
By Rowan Rodrik, 4 years ago, on April 15, 2009, at 22:04 |
When I clone a production database to a development database, I always need to empty the development database first. I could never find an SQL command to completely purge a database, bur, recently, I learned something about MySQL that surprised me: MySQL doesn't lose the user rights for a database when you drop it. So, purging a MySQL database (without losing any access data meta data about that DB) is as simple as issuing the following statements:
By Rowan Rodrik, 5 years ago, on July 12, 2008, at 01:07 |