Let's talk!
Clients
Services
Blog
About us
Careers
Let's talk!
SOFTWARE
HOUSE
Clients
Insights
Blog
Learnings
Careers
About us
Contact us
Learnings
Boost your knowledge with the insights from our expert team.
accessibility
accessibility
agile
agile
ai
ai
api
api
architecture
architecture
aws
aws
career
career
celery
celery
communication
communication
concurrency
concurrency
css
css
data
data
database
database
db
db
debug
debug
design
design
design system
design system
development
development
devops
devops
django
django
docker
docker
documentation
documentation
figma
figma
frontend
frontend
git
git
html
html
javascript
javascript
js
js
leadership
leadership
management
management
metrics
metrics
ml
ml
orm
orm
performance
performance
postgres
postgres
process
process
product
product
product design
product design
python
python
react
react
redux
redux
research
research
security
security
software
software
sql
sql
sre
sre
test
test
testing
testing
tests
tests
typescript
typescript
ui
ui
ux
ux
web
web
workflow
workflow
<p>Handling Concurrency Without Locks </p>
↗
https://hakibenita.com/django-concurrency
Elton Morais
May 2, 2023
Topics:
concurrency, database, scalability
<p>An alternative to soft_deleted_at is to create a table that will be auto populated with deleted records </p>
↗
https://brandur.org/fragments/deleted-record-insert
Vitor Rangel
Jan 11, 2023
Topics:
database, sql
<p>Testing Database Changes the Right Way </p>
↗
https://www.heap.io/blog/testing-database-changes-right-way
Ellias Silva
Dec 27, 2022
Topics:
database
<p>Beekeeper Studio - Open Source SQL Editor and Database Manager </p>
↗
https://www.beekeeperstudio.io/
Fellipe Souto
Apr 5, 2022
Topics:
database, postgres, sgbd
<p>Django’s Field Choices Don’t Constrain Your Data </p>
↗
https://adamj.eu/tech/2020/01/22/djangos-field-choices-dont-constrain-your-data/
Elton Morais
Feb 14, 2022
Topics:
database, django
<p>Export to CSV from PSQL using the copy command </p>
↗
https://dataschool.com/learn-sql/export-to-csv-from-psql/
Elton Morais
Dec 17, 2021
Topics:
database, postgresql, psql
<p>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</p>
↗
Rebeca Sarai
Dec 15, 2021
Topics:
database, db
<p>How we built a forever-free serverless SQL database </p>
↗
https://www.cockroachlabs.com/blog/how-we-built-cockroachdb-serverless/
Paulo Pigatto
Dec 10, 2021
Topics:
cockroachdb, database, serverless
<p>Scaling Datastores at Slack with Vitess </p>
↗
https://slack.engineering/scaling-datastores-at-slack-with-vitess/
Paulo Pigatto
Dec 9, 2021
Topics:
database, mysql, scalability
<p>Context Manager to launch exceptions when Django makes unexpected queries to ensure explicit control over DB overhead: </p>
↗
https://github.com/dabapps/django-zen-queries
Flavio Juvenal
Nov 25, 2021
Topics:
database, db, django, performance, sql
<p>Hosting SQLite databases on static pages </p>
↗
https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/
David Pierre
May 3, 2021
Topics:
database, db, development
<p>Overview postgresql indexes </p>
↗
https://www.enterprisedb.com/postgres-tutorials/overview-postgresql-indexes
Marcos Felipe
Sep 10, 2020
Topics:
database, postgres
<p>Zero downtime database migrations </p>
↗
https://www.rainforestqa.com/blog/2014-06-27-zero-downtime-database-migrations/
Filipe Ximenes
Jan 13, 2020
Topics:
database, devops
<p>Keeping Django database migrations backward compatible </p>
↗
https://medium.com/3yourmind/keeping-django-database-migrations-backward-compatible-727820260dbb
Joao Veras
Jan 13, 2020
Topics:
database, django
<p>Working with huge data sets in Django </p>
↗
https://blog.labdigital.nl/working-with-huge-data-sets-in-django-169453bca049
Filipe Ximenes
Dec 20, 2019
Topics:
database, django
<p>PostgreSQL at low level: stay curious! > </p>
↗
https://erthalion.info/2019/12/06/postgresql-stay-curious/
Rebeca Sarai
Dec 6, 2019
Topics:
database, postgres
<p>Best way to select random rows PostgreSQL: </p>
↗
https://stackoverflow.com/questions/8674718/best-way-to-select-random-rows-postgresql
Flávio Juvenal
Nov 7, 2019
Topics:
database, performance, postgres
<p>List all foreign keys referring to a table and if they're nullable or not with a simple SQL query in Postgres </p>
↗
https://gist.github.com/hugobessa/34be9ae0bd145e9140c1faf052e94d55
Hugo Bessa
Jan 9, 2019
Topics:
database, postgres
<p>quickly define a django management command for read-only shell </p>
↗
https://chase-seibert.github.io/blog/2012/12/21/read-only-django-shell.html
Carlos Coelho
Nov 29, 2018
Topics:
database, django, read-only, shell
<p>You should be careful when naming your heroku apps </p>
↗
https://www.varvet.com/blog/the-oh-shit-moment/
Luca Bezerra
Jul 24, 2018
Topics:
database, heroku, safety, security
<p>Show database, table and indexes size in Postgres: </p>
↗
https://www.niwi.nz/2013/02/17/postgresql-database-table-indexes-size/
Flávio Juvenal
Nov 3, 2017
Topics:
database, postgres
<p>Auto-incremented primary keys are not very safe, consider using uuid </p>
↗
https://medium.com/@jdedek/using-uuids-as-primary-keys-ca1fb409bb7c
Hugo Bessa
Oct 23, 2017
Topics:
database, security
<p>Intuitive proof of CAP theorem: </p>
↗
https://www.quora.com/Can-someone-provide-an-intuitive-proof-explanation-of-CAP-theorem
Flávio Juvenal
Jul 19, 2017
Topics:
cap, database
<p>In Django, <code>in_bulk</code> queryset method allows bulk fetching via primary key: #in-bulk</p>
↗
https://docs.djangoproject.com/en/1.11/ref/models/querysets/
Flávio Juvenal
Jun 9, 2017
Topics:
database, django
Close Cookie Preference Manager
Cookie Settings
By clicking “Accept all”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage and assist in our marketing efforts.
Check our privacy policies.
Strictly Necessary (Always Active)
Cookies required to enable basic website functionality.
Analytics
Cookies helping understand how this website performs, how visitors interact with the site, and whether there may be technical issues.
Marketing
Cookies used to deliver advertising that is more relevant to you and your interests.
Personalization
Cookies allowing the website to remember choices you make (such as your user name, language, or the region you are in).
Save settings
Accept all
We use Cookies to promote our services.
Settings and Privacy.
Accept