Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Tobias_Petry.sql Profile picture
Tobias_Petry.sql
@tobias_petry
The Database Guy. I am helping you get better with MySQL and PostgreSQL. Building: @stackbricksapp https://t.co/Yfe8XeSBfg https://t.co/ckxS6s2G0r
Oct 13, 2021 • 6 tweets • 3 min read
The improved PostgreSQL driver for Laravel is getting better and better.

Like the last release, this one again improves performance with a lot of new indexing functionality and some other nice improvements.

👇 All new features explained one-by-one PostgreSQL 10 introduced the concept of identity columns: It's generating unique incrementing values, you can use as (primary) columns. By specifying the always constraint ONLY the database is allowed to set them, it's protecting you from accidental overwrites 🔥
Sep 30, 2021 • 7 tweets • 3 min read
🎉 PostgreSQL 14 has been released today.

The amount of new features EVERY YEAR is incredible and there are again many nice features greatly improving your daily life. Most important this year is JSONB!

👇 Keep reading for an overview of the most important features. 👉Improved JSONB

If you never stored any JSON content in your tables you are definitely missing out on some very great features of PostgreSQL. From now on, you can use an improved syntax with much simpler support for updating nested values. postgresql.org/docs/14/dataty… Image
Sep 21, 2021 • 5 tweets • 3 min read
I finished a large chunk on improving the enhanced @PostgreSQL driver for @laravelphp. The new version has a lot of new indexing functionality to make your database queries really fast and use all the power of PostgreSQL 🔥

👇 All new features explained one-by-one Image With partial indexes you can limit an index to only handle specific rows to build smaller indexes or even do things you couldn't do before. You can e.g. make the email address now unique by ignoring duplicate values in soft-deleted rows.

Read more:
use-the-index-luke.com/sql/where-clau… Image