What I Wish Someone Told Me About Postgres
Postgres has many nuances and best practices that are important to understand.
Read more [challahscript.com]
Posts tagged with postgresql
Migrating from MySQL to Postgres using Laravel's query builder
– flareapp.io - submitted by Spatie
Discover how we migrated Flare from MySQL to Postgress with the help of Laravel's query builder.
Read more [flareapp.io]
Join 9,500+ smart developers
Every month I share what I learn from running Spatie, building Oh Dear, and maintaining 300+ open source packages. Practical takes on Laravel, PHP, and AI that you can actually use.
No spam. Unsubscribe anytime. You can also follow me on X.
Is it time to ditch MySQL and PostgreSQL for SQLite?
– onfold.sh - submitted by Nicolas Beauvais
SQLite is getting all the hype lately, but can it really compete with MySQL and PostgreSQL for production web applications?
Read more [onfold.sh]
Choose Postgres queue technology
A nice intro into using Postgres as your queuing solution, and some nice thoughts abou the importance of scale.
Read more [adriano.fyi]
Date Ranges in Laravel
– medium.com - submitted by Pavol Perdik
In this article Pavol Perdik writes about the native PostgreSQL type daterange and how to easily use it in Laravel.
Read more [medium.com]
What PostgreSQL has over other open source SQL databases
You may be asking yourself "Why PostgreSQL?" There are several choices for open source relational databases out there (we looked at MySQL, MariaDB and Firebird for this article), but what does PostgreSQL have that they don't? PostgreSQL's tag line claims that it's: "The world's most advanced open source database." We'll give you a few reasons why PostgreSQL makes this claim.https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases/
MySQL behaviour you should be aware of
I've used MySQL over the years and it has served me well. I didn't know the default behaviour is a bit messed up. Look at this video for some examples:
Because there's a lot of validation being done by the php-applications I work on, I've yet to run into the problems described above.Though the default configuration has some problems I'm not migrating my current projects from MySQL to something else. But for fresh new projects, I'll consider using PostgreSQL.
If you are considering this as well here's a guide by Chris Fidao (I stumbled upon the video above when reading that guide). If you are in any way interested in running your own server you have to subscribe to his excellent newsletter, Servers for Hackers, and buy the book with the same name.