Lessons about DB (page 2)
The links, tools and tips our engineers and designers share with each other, one “today I learned” at a time.
- lessons shared
- 68
- people sharing
- 8
- database started in
- 2017
Tech Insights· docs.djangoproject.com
How to make Django migrations that add unique fields:
Shared by
Read on docs.djangoproject.com- DB
- Django
- Migrations
- Uuid
docs.djangoproject.com
You can run EXPLAIN on a SQL query directly from a Django queryset:
Flavio Juvenal
Tech Insights· docs.djangoproject.com
You can run EXPLAIN on a SQL query directly from a Django queryset:
Shared by
Read on docs.djangoproject.com- DB
- Django
- Performance
Tech Insights
Datomic Cloud. A transactional database with a flexible data model, elastic scaling, and rich queries. Nubank uses Datomic to back a nimble, elastic microservices platform
Shared by
- Database
- DB
github.com
Context Manager to launch exceptions when Django makes unexpected queries to ensure explicit control over DB overhead:
Explicit control over database query execution in Django applications - dabapps/django-zen-queries
Flavio Juvenal
Tech Insights· github.com
Context Manager to launch exceptions when Django makes unexpected queries to ensure explicit control over DB overhead:
From github.com
Explicit control over database query execution in Django applications - dabapps/django-zen-queries
Shared by
Read on github.com- Database
- DB
- Django
- Performance
- SQL
prisma.io
5 ways to host PostgreSQL databases:
Compare PostgreSQL hosting options — self-managed, Docker, cloud-provider managed like AWS RDS, and fully managed Prisma Postgres — with a decision table, a "when to choose" guide, and an FAQ to help you pick the right one.
Flavio Juvenal
Tech Insights· prisma.io
5 ways to host PostgreSQL databases:
From prisma.io
Compare PostgreSQL hosting options — self-managed, Docker, cloud-provider managed like AWS RDS, and fully managed Prisma Postgres — with a decision table, a "when to choose" guide, and an FAQ to help you pick the right one.
Shared by
Read on prisma.io- Cloud
- DB
- PostgreSQL
- SQL
Tech Insights· hakibenita.com
Optimizing the Django Admin Paginator:
Shared by
Read on hakibenita.com- Admin
- DB
- Django
- SQL
Tech Insights· wiki.postgresql.org
Don't Do This in Postgres:
Shared by
Read on wiki.postgresql.org- DB
- PostgreSQL
2ndquadrant.com
Use "identity columns" instead of serial type in Postgres > 10:
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
Flavio Juvenal
Tech Insights· 2ndquadrant.com
Use "identity columns" instead of serial type in Postgres > 10:
From 2ndquadrant.com
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
Shared by
Read on 2ndquadrant.com- DB
- PostgreSQL
- SQL
nextplatform.com
It's Time to Start Paying Attention to Vector Databases:
The concepts underpinning vector databases are decades old, but it is only relatively recently that these are the underlying “secret weapon” of the
Flavio Juvenal
Tech Insights· nextplatform.com
It's Time to Start Paying Attention to Vector Databases:
From nextplatform.com
The concepts underpinning vector databases are decades old, but it is only relatively recently that these are the underlying “secret weapon” of the
Shared by
Read on nextplatform.com- DB
- Deeplearning
- Embedding
- Vector
gitlab.com
postgres-checkup – automated PostgreSQL health checks:
⚠️ ARCHIVED: This project is no longer maintained. See successor: npx postgresai checkup
Flavio Juvenal
Tech Insights· gitlab.com
postgres-checkup – automated PostgreSQL health checks:
From gitlab.com
⚠️ ARCHIVED: This project is no longer maintained. See successor: npx postgresai checkup
Shared by
Read on gitlab.com- DB
- Performance
- PostgreSQL
Tech Insights· github.com
django-add-default-value: This django Migration Operation can be used to transfer a Fields default value to the database scheme.
Shared by
Read on github.com- DB
- Django
- Migration
pgbarman.org
pgbarman - taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee:
Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity.Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.Version 3.20.1 (29 Sep 2026)| Release Notes
Flavio Juvenal
Tech Insights· pgbarman.org
pgbarman - taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee:
From pgbarman.org
Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity.Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.Version 3.20.1 (29 Sep 2026)| Release Notes
Shared by
Read on pgbarman.org- Backup
- DB
- PostgreSQL
- SQL
github.com
Django extension to allow working with 'clusters' of models as a single unit, independently of the database:
Django extension to allow working with 'clusters' of models as a single unit, independently of the database - wagtail/django-modelcluster
Flavio Juvenal
Tech Insights· github.com
Django extension to allow working with 'clusters' of models as a single unit, independently of the database:
From github.com
Django extension to allow working with 'clusters' of models as a single unit, independently of the database - wagtail/django-modelcluster
Shared by
Read on github.com- DB
- Django
- Model
phiresky.github.io
Hosting SQLite databases on static pages
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a
David Pierre
Tech Insights· phiresky.github.io
Hosting SQLite databases on static pages
From phiresky.github.io
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a
Shared by
Read on phiresky.github.io- Database
- DB
- Development
foxhound.systems
Speeding up SQL queries by orders of magnitude using UNION:
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
Flavio Juvenal
Tech Insights· foxhound.systems
Speeding up SQL queries by orders of magnitude using UNION:
From foxhound.systems
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
Shared by
Read on foxhound.systems- DB
- Performance
- PostgreSQL
- SQL
Book a call
Found it useful?
Let’s put it to work.
Tell us about your product and the problem in front of you. We’ll bring what we’ve learned on real projects.
Tell us about your product, and we’ll bring what we’ve learned.
Still prefer the good old email? Contact us
