I wrote a new first-year undergraduate course on databases (focussed on how to use query languages, not on DBMS internals). It covers SQL, relational algebra, JSON documents, Cypher, and Datalog. Notes are freely available here: www.cl.cam.ac.uk/teaching/262...
www.cl.cam.ac.uk
November 4, 2026 at 8:36 PM
I wrote a new first-year undergraduate course on databases (focussed on how to use query languages, not on DBMS internals). It covers SQL, relational algebra, JSON documents, Cypher, and Datalog. Notes are freely available here: www.cl.cam.ac.uk/teaching/262...
I've been building a small database: LuraDB.
Key-value, JSON documents and slim relational tables in one process on io_uring. Everything speaks REST, down to the single record: no driver, curl is enough. MCP embedded.
luradb.org
#Rust #Linux #Database #io_uring #MCP #FairSource #SelfHosted
Key-value, JSON documents and slim relational tables in one process on io_uring. Everything speaks REST, down to the single record: no driver, curl is enough. MCP embedded.
luradb.org
#Rust #Linux #Database #io_uring #MCP #FairSource #SelfHosted
LuraDB – your friendly neighborhood database
LuraDB is a Linux-first, REST-native multi-model database: key-value, JSON documents and slim relational tables in one small process on io_uring.
luradb.org
November 4, 2026 at 8:57 PM
I've been building a small database: LuraDB.
Key-value, JSON documents and slim relational tables in one process on io_uring. Everything speaks REST, down to the single record: no driver, curl is enough. MCP embedded.
luradb.org
#Rust #Linux #Database #io_uring #MCP #FairSource #SelfHosted
Key-value, JSON documents and slim relational tables in one process on io_uring. Everything speaks REST, down to the single record: no driver, curl is enough. MCP embedded.
luradb.org
#Rust #Linux #Database #io_uring #MCP #FairSource #SelfHosted
What got cut to fit SQL, relational algebra, JSON, Cypher and Datalog into one first-year term? That's already a lot of ground — was there a language you wanted in but had to leave out?
November 5, 2026 at 1:59 PM
What got cut to fit SQL, relational algebra, JSON, Cypher and Datalog into one first-year term? That's already a lot of ground — was there a language you wanted in but had to leave out?
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Java #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @micronautfw.bsky.social @juarezjunior.bsky.social
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle…
by Juarez Junior
rb.gy
November 4, 2026 at 12:32 PM
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Java #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @micronautfw.bsky.social @juarezjunior.bsky.social
There are many data modeling methods
@joereis.bsky.social identifies five and covers their pros and cons:
Relational - normal forms
Analytics - Inmon/Kimball
Application - JSON
ML/AI - vector
Knowledge - ontologies & taxonomies
Which camp are you in?
buff.ly/pXapiJh
@joereis.bsky.social identifies five and covers their pros and cons:
Relational - normal forms
Analytics - Inmon/Kimball
Application - JSON
ML/AI - vector
Knowledge - ontologies & taxonomies
Which camp are you in?
buff.ly/pXapiJh
The Five Camps of Data Modeling (and Which One You’re Stuck In)
Most data practitioners learned one way to model data and assumed it covered everything.
buff.ly
November 5, 2026 at 12:04 PM
There are many data modeling methods
@joereis.bsky.social identifies five and covers their pros and cons:
Relational - normal forms
Analytics - Inmon/Kimball
Application - JSON
ML/AI - vector
Knowledge - ontologies & taxonomies
Which camp are you in?
buff.ly/pXapiJh
@joereis.bsky.social identifies five and covers their pros and cons:
Relational - normal forms
Analytics - Inmon/Kimball
Application - JSON
ML/AI - vector
Knowledge - ontologies & taxonomies
Which camp are you in?
buff.ly/pXapiJh
The package operates as an interconnected relational database, comprising several comma-separated value (CSV) files and JavaScript Object Notation (JSON) manifests (DrillPicks_2026-10-27_2026-10-30_20261030T114629Z.csv is a list of posts picked for "drilldown" and comment inventory & analysis)
October 30, 2026 at 6:44 PM
The package operates as an interconnected relational database, comprising several comma-separated value (CSV) files and JavaScript Object Notation (JSON) manifests (DrillPicks_2026-10-27_2026-10-30_20261030T114629Z.csv is a list of posts picked for "drilldown" and comment inventory & analysis)
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Java #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @micronautfw.bsky.social @juarezjunior.bsky.social
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle…
by Juarez Junior
rb.gy
October 30, 2026 at 1:14 PM
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Java #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @micronautfw.bsky.social @juarezjunior.bsky.social
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @micronautfw.bsky.social @juarezjunior.bsky.social
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle…
by Juarez Junior
rb.gy
October 22, 2026 at 11:27 AM
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @micronautfw.bsky.social @juarezjunior.bsky.social
Stitching a vector store, a search engine and a SQL database together just to ship RAG? seekdb from keeps relational, vector, full-text, JSON and GIS data in one engine. Hybrid search runs in a single SQL statement, with AI_EMBED, AI_COMPLETE and AI_RERANK built in. It works with LangChain,...
October 24, 2026 at 12:19 AM
Stitching a vector store, a search engine and a SQL database together just to ship RAG? seekdb from keeps relational, vector, full-text, JSON and GIS data in one engine. Hybrid search runs in a single SQL statement, with AI_EMBED, AI_COMPLETE and AI_RERANK built in. It works with LangChain,...
The MySQL REST Service Component is now GA in #MySQL 26.10!
A big milestone for me: HTTPS #REST APIs with relational-to-JSON mapping, authentication and authorization, directly inside MySQL Server.
Building apps on MySQL? Read the 1st post in the series
blogs.oracle.com/mysql/introd...
A big milestone for me: HTTPS #REST APIs with relational-to-JSON mapping, authentication and authorization, directly inside MySQL Server.
Building apps on MySQL? Read the 1st post in the series
blogs.oracle.com/mysql/introd...
blogs.oracle.com
October 21, 2026 at 5:37 PM
The MySQL REST Service Component is now GA in #MySQL 26.10!
A big milestone for me: HTTPS #REST APIs with relational-to-JSON mapping, authentication and authorization, directly inside MySQL Server.
Building apps on MySQL? Read the 1st post in the series
blogs.oracle.com/mysql/introd...
A big milestone for me: HTTPS #REST APIs with relational-to-JSON mapping, authentication and authorization, directly inside MySQL Server.
Building apps on MySQL? Read the 1st post in the series
blogs.oracle.com/mysql/introd...
Using Claude to help write some lecture notes on databases, and it basically quoted my own book back to me (without me asking for it). I do know it's in the training data because I got letters about the Anthropic copyright settlement… still, feels pretty weird
![Quote from my book:
"Document databases are sometimes called schemaless, but that’s misleading, as the code that reads the data usually assumes some kind of structure—i.e., there is an implicit schema, but it is not enforced by the database [20]. A more accurate term is schema-on-read (the structure of the data is implicit, and only interpreted when the data is read), in contrast with schema-on-write (the traditional approach of relational databases, where the schema is explicit and the database ensures all written data conforms to it) [21].
Schema-on-read is similar to dynamic (runtime) type checking in programming languages, whereas schema-on-write is similar to static (compile-time) type checking. Just as the advocates of static and dynamic type checking have big debates about their relative merits [22], enforcement of schemas in database is a contentious topic, and in general there’s no right or wrong answer."](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:vzmlifz3ghar4cu2hj3srga2/bafkreibpd2l7lpvur3rfpxazycvnfz53gmtcnogrargp7svq53a7pytmy4)
![Quote from my book:
"The difference between the approaches is particularly noticeable in situations where an application wants to change the format of its data. For example, say you are currently storing each user’s full name in one field, and you instead want to store the first name and last name separately [23]. In a document database, you would just start writing new documents with the new fields and have code in the application that handles the case when old documents are read."](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:vzmlifz3ghar4cu2hj3srga2/bafkreigunnncvxluv6hogj7i2zplsfc7vbnuwjfrvj6m5eujtr6zrruvpe)
October 18, 2026 at 10:19 AM
Using Claude to help write some lecture notes on databases, and it basically quoted my own book back to me (without me asking for it). I do know it's in the training data because I got letters about the Anthropic copyright settlement… still, feels pretty weird
how about programs that call a relational database, how about differences in arithmetic semantics, or in the under-determination of specs (IEEE floating point, json etc.), how about how they handle timing and branching (which is observable behaviour to a cryptographic program!) etc etc etc.
October 14, 2026 at 1:25 AM
how about programs that call a relational database, how about differences in arithmetic semantics, or in the under-determination of specs (IEEE floating point, json etc.), how about how they handle timing and branching (which is observable behaviour to a cryptographic program!) etc etc etc.
Updated Post: Simple RESTful services with ORDS: Duality Views
Simple RESTful services with ORDS: Duality Views - andersswanson.dev
In this article, we’ll create a RESTful webservice that can GET/POST/PUT/DELETE relational JSON documents. The best part? We’ll use just a few lines of PL/SQL and zero lines of backend code to…
andersswanson.dev
October 13, 2026 at 6:47 PM
Updated Post: Simple RESTful services with ORDS: Duality Views
📰 New article by Ravi Teja Bellamkonda, Sachin Murkar, Bipin Nair
Modernizing document storage for search, scale, and agility
#AWS #Databases
Modernizing document storage for search, scale, and agility
#AWS #Databases
Modernizing document storage for search, scale, and agility
Storing extracted document data in a relational JSON or BLOB column works until you need search and scale. Learn how to recognize when document data has outgrown relational storage, and how to choose between Amazon DocumentDB and Amazon DynamoDB using a progressive, low-risk migration pattern.
aws.amazon.com
October 13, 2026 at 3:31 PM
📰 New article by Ravi Teja Bellamkonda, Sachin Murkar, Bipin Nair
Modernizing document storage for search, scale, and agility
#AWS #Databases
Modernizing document storage for search, scale, and agility
#AWS #Databases
The JSON Tiles system automatically extracts key fields from semi-structured data, enabling relational databases to perform analytics on JSON at native speeds while maintaining data flexibility.
#Json #Analytics #Database
#Json #Analytics #Database
JSON tiles: native-speed analytics on JSON data in relational systems
Source: Lobsters
realfeedapp.com
October 11, 2026 at 8:40 AM
The JSON Tiles system automatically extracts key fields from semi-structured data, enabling relational databases to perform analytics on JSON at native speeds while maintaining data flexibility.
#Json #Analytics #Database
#Json #Analytics #Database
→ What they did
Developed JSON Tiles, a system that automatically identifies key fields in data to allow relational databases to process JSON at near-native speeds.
Developed JSON Tiles, a system that automatically identifies key fields in data to allow relational databases to process JSON at near-native speeds.
October 11, 2026 at 8:40 AM
→ What they did
Developed JSON Tiles, a system that automatically identifies key fields in data to allow relational databases to process JSON at near-native speeds.
Developed JSON Tiles, a system that automatically identifies key fields in data to allow relational databases to process JSON at near-native speeds.
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @juarezjunior.bsky.social
October 3, 2026 at 11:31 AM
JSON Relational Duality Views with Micronaut, Micronaut Data, Oracle JDBC/UCP and the Oracle Database 26ai rb.gy/5j0qty #Micronaut #JSON #RelationalDualityViews #JavaOracleDB #JDBC #UCP #OracleAIDatabase #JavaOracleDB #JDBC #UCP #OracleAIDatabase #Oracle @juarezjunior.bsky.social
For those wondering what the heck XSTL is, its the language that tells the browser how to turn XML into other things, like HTML. It lets a web based site or app to talk to a relational database. Lots of web stuff uses JSON, or talks to a MYSQL database.
October 2, 2026 at 2:04 PM
For those wondering what the heck XSTL is, its the language that tells the browser how to turn XML into other things, like HTML. It lets a web based site or app to talk to a relational database. Lots of web stuff uses JSON, or talks to a MYSQL database.
JSON is another (semi annoying) jump in technology.
No more memorizing SQL statements for relational databases when you can just dump json/jsonl and use json for everything, for better or worse, without the additional requirements of mastering every feature in some vendor locked SQL
No more memorizing SQL statements for relational databases when you can just dump json/jsonl and use json for everything, for better or worse, without the additional requirements of mastering every feature in some vendor locked SQL
September 28, 2026 at 7:19 PM
JSON is another (semi annoying) jump in technology.
No more memorizing SQL statements for relational databases when you can just dump json/jsonl and use json for everything, for better or worse, without the additional requirements of mastering every feature in some vendor locked SQL
No more memorizing SQL statements for relational databases when you can just dump json/jsonl and use json for everything, for better or worse, without the additional requirements of mastering every feature in some vendor locked SQL
Do not overcomplicate your tech stack with separate vector stores.
PostgreSQL with pgvector allows you to combine relational joins, JSON storage, and vector similarity search within a single database.
#PostgreSQL #pgvector #AIAgents #DataArchitecture #Database
PostgreSQL with pgvector allows you to combine relational joins, JSON storage, and vector similarity search within a single database.
#PostgreSQL #pgvector #AIAgents #DataArchitecture #Database
September 29, 2026 at 4:36 AM
Do not overcomplicate your tech stack with separate vector stores.
PostgreSQL with pgvector allows you to combine relational joins, JSON storage, and vector similarity search within a single database.
#PostgreSQL #pgvector #AIAgents #DataArchitecture #Database
PostgreSQL with pgvector allows you to combine relational joins, JSON storage, and vector similarity search within a single database.
#PostgreSQL #pgvector #AIAgents #DataArchitecture #Database
Memory types do not dictate database count. Hindsight implements vector, full-text, relational, JSON, and graph access on PostgreSQL. I would separate execution state, evidence, and derived knowledge by responsibility before assigning them separate services.
Read more
Continuation of the one-engine proposal. This is a proposed architecture, not a selected product or a deployed system.
cards.smith.wiki
September 29, 2026 at 9:20 AM
Memory types do not dictate database count. Hindsight implements vector, full-text, relational, JSON, and graph access on PostgreSQL. I would separate execution state, evidence, and derived knowledge by responsibility before assigning them separate services.
New on Foojay by @bazlur.ca : Learn how MySQL JSON Duality Views let you work with relational and document data models at the same time. Great for building Java apps that need both structured queries and flexible JSON APIs.
foojay.io/today/one-da...
#Java #MySQL #JSON
foojay.io/today/one-da...
#Java #MySQL #JSON
One Database, Two Models: Building AI-Friendly Java Applications with MySQL JSON Duality Views
Explore MySQL JSON Duality Views in Java: simpler reads, safe document writes, ORM comparisons, and read-only tools for a local AI assistant.
foojay.io
September 28, 2026 at 7:09 AM
New on Foojay by @bazlur.ca : Learn how MySQL JSON Duality Views let you work with relational and document data models at the same time. Great for building Java apps that need both structured queries and flexible JSON APIs.
foojay.io/today/one-da...
#Java #MySQL #JSON
foojay.io/today/one-da...
#Java #MySQL #JSON
cant help but wonder how much global bandwidth, disk space,e and compute is technically "wasted" because all the data nowadays is json taken into and out of a relational database
September 28, 2026 at 12:40 PM
cant help but wonder how much global bandwidth, disk space,e and compute is technically "wasted" because all the data nowadays is json taken into and out of a relational database
PostgreSQL and the Resurgence of Relational SQL Databases
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en
September 25, 2026 at 5:57 PM
PostgreSQL and the Resurgence of Relational SQL Databases
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en