Generate Primary Keys (almost) Automatically
What if your database design is so poor that you need to refactor tables in order to add primary keys?
written sometime in July 2019
|
Blogger/Blogspot and Spam Comments
The problem of spam within blog comments is quite annoying!
written sometime in July 2019
|
PostgreSQL & recovery.conf
The coming version of PostgreSQL, 12, will loose the recovery.conf file. It will get some time to get used to!
written sometime in July 2019
|
PostgreSQL Administrator Account WITH NOLOGIN (recover your role)
Today I got an email from a friend of mine that locked out of his own database due to a little mistake.
written sometime in June 2019
|
Importing data from MSSQL is faster than I thought
A few months ago I set up a Foreign Data Wrapper against a Microsoft SQL Server to import historical data.
I’m quite impressive about how quick the bulk import is.
written sometime in June 2019
|