Note: This section of the site is under heavy construction, tread carefully.

Bookmarks tagged with “sql”

20 bookmarks by garrettc


Django filter - filter(A).filter(B) vs filter(A, B)

"Sometimes, when chaining filters together – SomeModels.objects.filter(a=A).filter(b=B) – we get duplicate objects in our queryset. In this article, we’ll explore & explain why."

Bookmarked on #



Lesser Known PostgreSQL Features

"Most of us are not aware of all the features in tools we use on a daily basis, especially if it's big and extensive like PostgreSQL. With PostgreSQL 14 released just a few weeks ago, what a better opportunity to shed a light on some lesser known features that already exist in PostgreSQL, but you may not know."

Bookmarked on #


SQL queries don't start with SELECT - Julia Evans

SQL queries don't start with SELECT

Bookmarked on #



Select Star SQL

“An interactive book which aims to be the best place on the internet for learning SQL. It is free of charge, free of ads and doesn't require registration or downloads. It helps you learn by running queries against a real-world dataset to complete projects of consequence. It is not a mere reference page — it conveys a mental model for writing SQL.”

Bookmarked on #


Sqlectron

A simple and lightweight SQL client desktop/terminal with cross database and platform support.

Bookmarked on #


Say NO to Venn Diagrams When Explaining JOINs

In recent times, there have been a couple of tremendously popular blog posts explaining JOINs using Venn Diagrams. After all, relational algebra and SQL are set oriented theories and languages, so it only makes sense to illustrate set operations like JOINs using Venn Diagrams. Right? Google seems to say so: Everyone uses Venn Diagrams to…

Bookmarked on #


Embulk

Open-source bulk data loader that helps data transfer between various databases, storages, file formats, and cloud services.

Bookmarked on #


Visual Guide to NoSQL Systems

"There are so many NoSQL systems these days that it's hard to get a quick overview of the major trade-offs involved when evaluating relational and non-relational systems in non-single-server environments."

Bookmarked on #






Use The Index, Luke!

A free tutorial covering SQL indexing and SQL tuning for developers

Bookmarked on #


MySQL and Postgres command equivalents

I'm delving into a lot more Postgres, and I'm getting confused.

Bookmarked on #


Useful temporal functions & queries

A collection of some common and useful time & date calculations and equations.

Bookmarked on #



SQL joins explained with a venn diagram

"If you have tried to understand how joins work and constantly get confused about what join to use, you just need to keep a simple picture in mind"

Bookmarked on #


Quick wins with MySQL

Useful quick tricks for getting MySQL to run a little better.

Bookmarked on #