"PostgreSQL and Databricks founders join forces for DBOS to create a new type of operating system"

Funny, I was just watching a video earlier today about how Postgres has expanded from a database system to a complete backend stack.

But here, they're talking about something different.

"Today DBOS announced that it has raised $8.5 million in seed funding as well as the launch of its first product, DBOS Cloud, which provides a new type of cloud-native operating system for cloud application deployment."

"Today, a database is a type of application that runs on top of an operating system, which in the cloud is often Linux. DBOS takes a radically different approach to operating systems by running the operating system on top of a high-performance database."

"Operating system services, such as messages, scheduling and file operations, those are all written in SQL on top of a very high-performance OLTP DBMS [Online Transaction Processing Database Management System]."

"Taking aim at Linux and the Kubernetes container orchestration system and the etcd key value store, they say."

This isn't the first time I've heard of someone saying a database should be at the heart of an operating system. But it's the first time I've heard of anyone making a serious attempt to do it.

PostgreSQL and Databricks founders join forces for DBOS to create a new type of operating system - VentureBeat

#solidstatelife #computerscience #operatingsystems #databases

PostgreSQL and Databricks founders join forces for DBOS to create a new type of operating system

DBOS was developed to address the challenges of managing the massive state of modern operating systems.

Open source CockroachDB tempts legacy databases to crawl into the cloud age

CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data. CockroachDB is wire-compatible with PostgreSQL.

CockroachDB has released its 23.2 iteration containing new features designed to tempt mainframe and other legacy database users to shift workloads to its distributed cloud-based system.

In the new release, the database-as-a-service company, whose customers include Comcast, audio company Bose, and cosmetics firm Lush, said it had rebuilt stored procedures to be significantly more powerful.

See https://www.theregister.com/2024/01/29/cockroachdb_23_2/
#Blog, #databases, #opensource, #technology

Airsequel claims to use AI prompts to generate SQL databases for you, make a GraphQL API, make a Spreadsheet UI, generate cloud functions, by which they mean TypeScript and Python code to run on cloud servers, and generate dashboards for visualization of your data.

"Airsequel automatically generates a complete GraphQL API and provides a spreadsheet UI, a SQL workbench, cloud functions, and a dashboard builder for your SQLite databases and CSV files."

"Utilize AI to effortlessly generate SQL queries. Simplify data retrieval and elevate your analytics with minimal manual input."

One interesting bit is that they make SQLite databases. The SQL can probably be easily adapted for other databases. I use SQLite for a ton of stuff, so it's interesting to see other people sticking up for it. Why SQLite? They say:

"SQLite is the most deployed database for good reason: It's fast, stable, self-contained, highly reliable, fully-featured, supported until at least 2050, and the only database recommended by the US Library of Congress for long-term archival."

Airsequel

#solidstatelife #ai #genai #databases #sql

How to migrate data from WordPress to Django?

Hi all, in my job training i'm working on creating a new version of the smart map

The current website is using WordPress for the backend and the version i'm working on uses Django. I'd like to migrate data from the WordPress database into Django

From what i've been able to gather there are these alternatives:
* Using Django's inspectdb (as described here)
* Exporting the WP data to XML and then parsing this data with a custom script (maybe something like this)

What would you recommend? Are there other options?

#WordPress #Django #DataMigration #programming #databases

● NEWS ● #YottaDB #Databases ☞ YottaDB r1.34 Released https://yottadb.com/yottadb-r1-34-released/

● NEWS ● #SimonWillison #Databases ☞ #GulagDrive to #SQLite https://simonwillison.net/2022/Feb/20/google-drive-to-sqlite/

Google Drive to SQLite

I released a new tool this week: google-drive-to-sqlite. It’s a CLI utility for fetching metadata about files in your Google Drive and writing them to a local SQLite database. It’s …

#Databases: pgBackRest 2.37, CoC, JDBC, and More • Tux Machines ⇨ http://www.tuxmachines.org/node/161578 #GNU #Linux #TuxMachines

● NEWS ● #DataStation #Databases ☞ The world of #PostgreSQL wire compatibility https://datastation.multiprocess.io/blog/2022-02-08-the-world-of-postgresql-wire-compatibility.html

● NEWS ● #JeremySchneider #Databases ☞ A Hairy #PostgreSQL Incident https://ardentperf.com/2022/02/10/a-hairy-postgresql-incident/

A Hairy PostgreSQL Incident

It was 5:17pm today, just as I was wrapping up work for the day, and my manager pinged me with the following chat: <manager>: Hi Jeremy – we have a <other team> ticket – esc…

● NEWS ● #Earthly #Databases #Database ☞ #Golang SQLite database/sql https://earthly.dev/blog/golang-sqlite/

Golang SQLite database/sql

Welcome back. I’m an experienced developer, learning Golang by building an activity tracker. Last time I made a command-line client to connect to t...

#Databases: MongoDB/NoSQL, Firebird, and Rqlite/SQLite • Tux Machines ⇨ http://www.tuxmachines.org/node/160798 #GNU #Linux #TuxMachines

● NEWS ● #Rlang #Databases ☞ How To Connect R Shiny to #Postgres Database – The Definite Guide https://www.r-bloggers.com/2022/01/how-to-connect-r-shiny-to-postgres-database-the-definite-guide/

How To Connect R Shiny to Postgres Database – The Definite Guide

Managing database connections can be messy at times. It’s always easier to read and write to local CSV files. That doesn’t mean it’s the right thing to do, as most production environments have data stored in one or multiple databases. As a data...

● NEWS ● #YottaDB #Databases ☞ Fuzz Testing #YottaDB https://yottadb.com/fuzz-testing-yottadb/

Fuzz Testing YottaDB - YottaDB

Summary Every day, we find fault with our software, so that you don’t! Robustness in software is a mark of quality that’s often easy to lose in development. Thanks to Zachary Minneker of Security Innovation, Inc., we are implementing fuzz testing...

● NEWS ● #Geshan #Databases ☞ #Postgres with #Docker and Docker compose a step-by-step guide for beginners https://geshan.com.np/blog/2021/12/docker-postgres/

Postgres with Docker and Docker compose a step-by-step guide for beginners

Learn how to set up and run PostgreSQL with docker and docker-compose in this step-by-step tutorial. It also shows how to add Postgres to an existing project.

#Databases: Firebird, PostgreSQL, and #SQLite • Tux Machines ⇨ http://www.tuxmachines.org/node/159500 #GNU #Linux #TuxMachines

● NEWS ● #MarcelWeiher #Databases #Database #DB ☞ Inserting 130M SQLite Rows per Minute...from a Scripting Language https://blog.metaobject.com/2021/07/inserting-130m-sqlite-rows-per.html

● NEWS ● #JamieBrandon #Databases ☞ Have you tried rubbing a database on it? https://www.scattered-thoughts.net/writing/hytradboi/

● NEWS ● #YottaDB #Databases ☞ Acculturation Workshop https://docs.yottadb.net/AcculturationGuide/acculturation.html

● NEWS ● #MaheshBalakrishnan #Databases ☞ 42 things I learned from building a production #database https://maheshba.bitbucket.io/blog/2021/10/19/42Things.html

● NEWS ● #ACM #Databases #Database #DB ☞ A Conversation with Margo Seltzer and Mike Olson: The history of #BerkeleyDB https://queue.acm.org/detail.cfm?id=3501713