Postgres
6 articles
Using Constraints to Protect Calendar Data in PostgreSQLThink about the lines of code you would have to write in order to manage a scheduling system. Duration checks, start and end time requirements as well as checking for overlap! You could spend a few days writing all that code or you could let PostgreSQL do it better with 5 lines of SQL.
Handling Dates and Times Properly in PostgresHandling dates properly is delicate business and, thankfully, Postgres gives you many tools to help make sure you store date information correctly. But that only works if you know what's going on!
Striking Gold in My ArchivesDigging through my archives of hundreds of videos, I found an oldy but goody - publishing it for you to enjoy!
Hello PostgreSQLIn this production, a SQL Server DBA (Rob Sullivan) and a developer (Rob Conery) take a deep dive into PostGreSQL (v9.1) and are surprised by just how capable, intelligent and *fast* PostGreSQL is.
Creating a Full Text Search Engine in PostgreSQL, 2022Writing a full text index in PostgreSQL is an art form. You need to know what your users are looking so you can build the right index AND you need to understand how they write their search terms. Thankfully, Postgres is here to help.
Importing a CSV Into PostgreSQL Like a ProImporting data into PostgreSQL can be time consuming and painful, unless you toss the GUI tools and use scripts.



