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
|
A recursive CTE to get information about partitions
I was wondering about writing a function that provides a quick status about partitioning. But wait, PostgreSQL has recursive CTEs!
written sometime in June 2019
|
Checking the sequences status on a single pass
It is quite simple to wrap a couple of queries in a function to have a glance at all the sequences and their cycling status.
written sometime in June 2019
|
Happy Birthday Java!
Java has just turned 24 years old. Happy Birthday Java!
written sometime in June 2019
|
FizzBuzz (in both plpgsql and SQL)
While listening to a great talk by Benno Rice, I was pointed to the FizzBuzz alghortim. How hard could it be to implement it using PostgreSQL?
written sometime in June 2019
|