news
Databases: Postgres and SQLite News
-
PostgreSQL ☛ Loongson loong64 packages on apt.postgresql.org
We have a new architecture on apt.postgresql.org: Loongson loong64, a Chinese processor architecture.
The build host for the architecture is running on a Loongson 3B6000 board provided by the loongfans.cn community.
-
Redowan Delowar ☛ Postgres as an isolation reference model
Part of that is because I like thinking in Postgres. There’s also the usual interview move: the system starts at a modest scale, then the interviewer cranks it up by 100x for shits and giggles. With regular Postgres, that may mean manual sharding or switching databases. Either option can change the transaction boundary and force a substantial redesign. NewSQL lets me keep the relational model and distributed transactions as the system grows.
-
Joe Wilson ☛ SQLite for Everything | JoeCode
In my humble opinion, the power of SQLite comes from three sources:
1. It is rock-solid and stable.
2. It is easy to run, install and scale. Mostly because there is nothing to run.
3. It massively simplifies your IT setup by being not only an RDBMS, but also a full-text search engine, a document store, a cache, a vector index, and a file format.Let’s have a closer look.
-
The Sporks Space ☛ Things I want in a modern relational query language
I think one of the biggest causes of NoSQL is that while SQL is a powerful language because of the ideas behind it, it’s often implemented in clumsy and archaic ways. A language that learns from SQL could make relational data better to manipulate for programmers. I’ll try to think of things similar to those that I have dealt with in real-world situations and how a better query language could have helped. I’d love discussion on what else could be done.
For what it’s worth, my background with RDBMSes is mostly in MySQL and Db2, but I have used SQLite, SQL Server, Oracle, and Postgres in anger enough (in descending order of familiarity).
-
Tara Stella ☛ GixSQL, COBOL and FreeBSD
This is more of a small bookmark for my own sake, rather than a full article.
I created a tiny repository with working GnuCOBOL, GixSQL and SQLite examples: gnucobol-gixsql-sqlite-examples
It is intentionally small.