#databases — Public Fediverse posts

River Engineering writer Vivian Mathews retells their company's 16-month-long saga to replace an aging accounting ledger system with a refactored, highly optimized new version. They go through the nitty-gritty of how they successfully pulled-off a zero-downtime migration including code examples and key takeaways for the TL;DR crowd.

"We replaced our ledger with two functions"

https://river.com/content/we-replaced-our-ledger-with-two-functions

#programming #databases #accounting #ledgers #optimization #refactoring #migration #testing

River Engineering writer Vivian Mathews retells their company's 16-month-long saga to replace an aging accounting ledger system with a refactored, highly optimized new version. They go through the nitty-gritty of how they successfully pulled-off a zero-downtime migration including code examples and key takeaways for the TL;DR crowd.

"We replaced our ledger with two functions"

https://river.com/content/we-replaced-our-ledger-with-two-functions

#programming #databases #accounting #ledgers #optimization #refactoring #migration #testing

River Engineering writer Vivian Mathews retells their company's 16-month-long saga to replace an aging accounting ledger system with a refactored, highly optimized new version. They go through the nitty-gritty of how they successfully pulled-off a zero-downtime migration including code examples and key takeaways for the TL;DR crowd.

"We replaced our ledger with two functions"

https://river.com/content/we-replaced-our-ledger-with-two-functions

#programming #databases #accounting #ledgers #optimization #refactoring #migration #testing

River Engineering writer Vivian Mathews retells their company's 16-month-long saga to replace an aging accounting ledger system with a refactored, highly optimized new version. They go through the nitty-gritty of how they successfully pulled-off a zero-downtime migration including code examples and key takeaways for the TL;DR crowd.

"We replaced our ledger with two functions"

https://river.com/content/we-replaced-our-ledger-with-two-functions

#programming #databases #accounting #ledgers #optimization #refactoring #migration #testing

River Engineering writer Vivian Mathews retells their company's 16-month-long saga to replace an aging accounting ledger system with a refactored, highly optimized new version. They go through the nitty-gritty of how they successfully pulled-off a zero-downtime migration including code examples and key takeaways for the TL;DR crowd.

"We replaced our ledger with two functions"

https://river.com/content/we-replaced-our-ledger-with-two-functions

#programming #databases #accounting #ledgers #optimization #refactoring #migration #testing

New things for regular expressions in PostgreSQL (pg_tre and pg_re2) via @fanf https://lobste.rs/s/b53fwj #databases
https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/

New things for regular expressions in PostgreSQL (pg_tre and pg_re2) via @fanf https://lobste.rs/s/b53fwj #databases
https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/

New things for regular expressions in PostgreSQL (pg_tre and pg_re2) via @fanf https://lobste.rs/s/b53fwj #databases
https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/

New things for regular expressions in PostgreSQL (pg_tre and pg_re2) via @fanf https://lobste.rs/s/b53fwj #databases
https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/

New things for regular expressions in PostgreSQL (pg_tre and pg_re2) via @fanf https://lobste.rs/s/b53fwj #databases
https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/

Read your own writes, off the primary via @caius https://lobste.rs/s/vq68cd #databases
https://boringsql.com/posts/read-your-own-writes/

Read your own writes, off the primary via @caius https://lobste.rs/s/vq68cd #databases
https://boringsql.com/posts/read-your-own-writes/

Read your own writes, off the primary via @caius https://lobste.rs/s/vq68cd #databases
https://boringsql.com/posts/read-your-own-writes/

Read your own writes, off the primary via @caius https://lobste.rs/s/vq68cd #databases
https://boringsql.com/posts/read-your-own-writes/

Read your own writes, off the primary via @caius https://lobste.rs/s/vq68cd #databases
https://boringsql.com/posts/read-your-own-writes/

Please stop calling databases CP or AP (2015)

https://martin.kleppmann.com/2015/05/11/please-stop-calling-databases-cp-or-ap.html

Comments: https://news.ycombinator.com/item?id=49521490

#HackerNews #databases #CP #AP #dataarchitecture #datastorage #technology

Please stop calling databases CP or AP (2015)

https://martin.kleppmann.com/2015/05/11/please-stop-calling-databases-cp-or-ap.html

Comments: https://news.ycombinator.com/item?id=49521490

#HackerNews #databases #CP #AP #dataarchitecture #datastorage #technology

Please stop calling databases CP or AP (2015)

https://martin.kleppmann.com/2015/05/11/please-stop-calling-databases-cp-or-ap.html

Comments: https://news.ycombinator.com/item?id=49521490

#HackerNews #databases #CP #AP #dataarchitecture #datastorage #technology

Please stop calling databases CP or AP (2015)

https://martin.kleppmann.com/2015/05/11/please-stop-calling-databases-cp-or-ap.html

Comments: https://news.ycombinator.com/item?id=49521490

#HackerNews #databases #CP #AP #dataarchitecture #datastorage #technology

Please stop calling databases CP or AP (2015)

https://martin.kleppmann.com/2015/05/11/please-stop-calling-databases-cp-or-ap.html

Comments: https://news.ycombinator.com/item?id=49521490

#HackerNews #databases #CP #AP #dataarchitecture #datastorage #technology

AWS: DuckDB will provide 'connective tissue' across the data estate https://www.theregister.com/databases/2026/09/01/aws-duckdb-will-provide-connective-tissue-across-the-data-estate/5293304 #theRegister #Databases

AWS: DuckDB will provide 'connective tissue' across the data estate https://www.theregister.com/databases/2026/09/01/aws-duckdb-will-provide-connective-tissue-across-the-data-estate/5293304 #theRegister #Databases

AWS: DuckDB will provide 'connective tissue' across the data estate https://www.theregister.com/databases/2026/09/01/aws-duckdb-will-provide-connective-tissue-across-the-data-estate/5293304 #theRegister #Databases

Condensing the classification found in "Still Building the Memex" (Davies 2010), I'd be comfortable dividing personal knowledge base structural frameworks into two categories: Link-based and Category-based.

Tree-structured and graph-structured organizers are link-based. Tag-structured organizers are category-based. Because select and join are key-matching operations, relational #databases are also category-based.

For the link-based systems the primitive operation is to follow a link. For the category-based systems the primitive operation is to separate a collection of data into items belonging to a particular category and items not belonging to the category.

(Thread continues... 🧵)

Condensing the classification found in "Still Building the Memex" (Davies 2010), I'd be comfortable dividing personal knowledge base structural frameworks into two categories: Link-based and Category-based.

Tree-structured and graph-structured organizers are link-based. Tag-structured organizers are category-based. Because select and join are key-matching operations, relational #databases are also category-based.

For the link-based systems the primitive operation is to follow a link. For the category-based systems the primitive operation is to separate a collection of data into items belonging to a particular category and items not belonging to the category.

(Thread continues... 🧵)

Condensing the classification found in "Still Building the Memex" (Davies 2010), I'd be comfortable dividing personal knowledge base structural frameworks into two categories: Link-based and Category-based.

Tree-structured and graph-structured organizers are link-based. Tag-structured organizers are category-based. Because select and join are key-matching operations, relational #databases are also category-based.

For the link-based systems the primitive operation is to follow a link. For the category-based systems the primitive operation is to separate a collection of data into items belonging to a particular category and items not belonging to the category.

(Thread continues... 🧵)

Condensing the classification found in "Still Building the Memex" (Davies 2010), I'd be comfortable dividing personal knowledge base structural frameworks into two categories: Link-based and Category-based.

Tree-structured and graph-structured organizers are link-based. Tag-structured organizers are category-based. Because select and join are key-matching operations, relational #databases are also category-based.

For the link-based systems the primitive operation is to follow a link. For the category-based systems the primitive operation is to separate a collection of data into items belonging to a particular category and items not belonging to the category.

(Thread continues... 🧵)

Condensing the classification found in "Still Building the Memex" (Davies 2010), I'd be comfortable dividing personal knowledge base structural frameworks into two categories: Link-based and Category-based.

Tree-structured and graph-structured organizers are link-based. Tag-structured organizers are category-based. Because select and join are key-matching operations, relational #databases are also category-based.

For the link-based systems the primitive operation is to follow a link. For the category-based systems the primitive operation is to separate a collection of data into items belonging to a particular category and items not belonging to the category.

(Thread continues... 🧵)

Folks often ask me what is 3rd Normal Form and why I like it so much :ablobcatbongokeyboard: So I put together a page on my wiki explaining the most common Normal Forms :sql:

Books often describe them with vast details - I wanted to make a short and handy intro :blobcatreading:

#datamodeling #knowledge #useful #wiki #databases

Folks often ask me what is 3rd Normal Form and why I like it so much :ablobcatbongokeyboard: So I put together a page on my wiki explaining the most common Normal Forms :sql:

Books often describe them with vast details - I wanted to make a short and handy intro :blobcatreading:

#datamodeling #knowledge #useful #wiki #databases

Folks often ask me what is 3rd Normal Form and why I like it so much :ablobcatbongokeyboard: So I put together a page on my wiki explaining the most common Normal Forms :sql:

Books often describe them with vast details - I wanted to make a short and handy intro :blobcatreading:

#datamodeling #knowledge #useful #wiki #databases

Folks often ask me what is 3rd Normal Form and why I like it so much :ablobcatbongokeyboard: So I put together a page on my wiki explaining the most common Normal Forms :sql:

Books often describe them with vast details - I wanted to make a short and handy intro :blobcatreading:

#datamodeling #knowledge #useful #wiki #databases

Folks often ask me what is 3rd Normal Form and why I like it so much :ablobcatbongokeyboard: So I put together a page on my wiki explaining the most common Normal Forms :sql:

Books often describe them with vast details - I wanted to make a short and handy intro :blobcatreading:

#datamodeling #knowledge #useful #wiki #databases

A Better SQL in 11 Lines of Code https://lobste.rs/s/xnljk9 #databases
https://prela-lang.org/tutorial/

A Better SQL in 11 Lines of Code https://lobste.rs/s/xnljk9 #databases
https://prela-lang.org/tutorial/

A Better SQL in 11 Lines of Code https://lobste.rs/s/xnljk9 #databases
https://prela-lang.org/tutorial/

A Better SQL in 11 Lines of Code https://lobste.rs/s/xnljk9 #databases
https://prela-lang.org/tutorial/

A Better SQL in 11 Lines of Code https://lobste.rs/s/xnljk9 #databases
https://prela-lang.org/tutorial/

Business Wire:

#Physics #AppliedMathematics #ComputationalScience #CognitiveScience #InformationRetrieval #GraphTheory #Rust #Databases #AI

https://github.com/Lucerna-Labs/atom-db

#NVIDIA published a blog post where they present GQE, a GPU-based query engine. Querying data from databases with GPU accelleration is beyond cool, and will certainly optimize the storage requirements for #bigdata due to enabling for more efficient compression algorithms. Here is the blog post:

Designing GPU-Accelerated Query Engines with NVIDIA GQE

#bigdata #databases #polars #pandas #datascience

Former University of Michigan Football Coach Indicted on Charges of Unauthorized Access and Identity Theft https://thecyberexpress.com/ex-coach-indicted-for-unauthorized-access/ #TheCyberExpressNews #unauthorizedaccess #TheCyberExpress #FirewallDaily #identitytheft #CyberNews #databases #FBI

Millions of WordPress sites get forced update to patch critical plugin flaw - Enlarge (credit: Getty Images)

Millions of WordPress sites hav... - https://arstechnica.com/?p=1835318 #contentmanagementsystems #vulnerabilities #databases #wordpress #hacking #biz&it

Hasura raises $9.9M Series A to simplify GraphQL for developers - Hasura, a startup working to solve developer problems around connecting to databases when using the ... more: http://feedproxy.google.com/~r/Techcrunch/~3/XKa5AQ6HM0o/ #vertexventures #opensource #developer #databases #startups #funding #hasura #apis