Awesome post on how to write SQL:

UPDATE table_name SET array_col = ARRAY(SELECT DISTINCT UNNEST(array_col) ORDER BY 1) where array_length(array_col, 1) > 1;

In Python: enjoy the ease of working with your data as ordinary objects in memory.

Data are moved in and out of memory as needed, so databases can be as large as needed.

In Postgres: index and search your data using PostgreSQL, from within your application and externally.

Within your application, search results may be returned as application objects, or as data, depending on your needs.

Transactional and built on mature technology for reliability.

RT @felixge: The “Lazy materialized views” technique in this article is really genius. Kudos to Jack Christensen. #postgres

Autovacuum is not the enemy -

age=lt.13&(student=eq.true|gender=eq.M)&group_by=sum(age),grade,gender&having=min(age)=gt.13&order_by=age.desc,height.asc&page=20&page_size=100&x=123&y=456

into

Query {
filters: [
Filter {
connector: None,
condition: Condition {
left: Column("age"),
equality: LT,
right: Number(13)
},
subfilter: [
Filter {
...