#databases

waynerad@diasp.org

"Why do you need a time series database inside a car?"

That's a good question. Sometimes I wonder if we've crossed the point where further complexification of cars doesn't yield much benefit. But let's continue.

"As automotive intelligence progresses, vehicles generate increasing amounts of time-series data from various sources. This leads to high costs in data collection, transmission, and storage. GreptimeDB's Integrated Vehicle-Cloud Solution addresses these issues by leveraging the advanced computational capabilities of modern on-vehicle devices. Unlike traditional vehicle-cloud coordination where vehicles are mere data collectors, this new approach treats them as full-fledged servers capable of running complex tasks locally. The evolution from 32-bit microcontrollers to powerful chip modules like Qualcomm's 8155 or 8295 has enabled intelligent vehicles to perform edge computing efficiently, reducing transmission costs and improving overall efficiency."

"GreptimeDB is a cloud-native time-series database built on a highly scalable foundation. However, we did not initially anticipate it running on edge devices such as vehicles, which has presented significant challenges."

"The first challenge is resource usage constraints. GreptimeDB runs in the vehicle's cockpit domain controller and must minimize CPU and memory usage to avoid interfering with infotainment systems."

"The second concern is robustness; GreptimeDB collects critical diagnostic metrics from the CAN bus, so any crashes could result in data loss."

"CAN" here stands for "controller area network" and is a data bus inside vehicles that replaces masses of wires that go directly from components to other components -- it allows any "electronic control unit" (ECU) connected to the bus to communicate with any other.

"Lastly, unlike servers in datacenters, vehicle-based GreptimeDB operates under various conditions -- frequent power cycles, fluctuating ADAS data rates due to changing road traffic, etc. -- and needs to adapt while remaining stable and efficient."

"ADAS" stands for "advanced driver-assistance systems".

How to build a TSDB Running inside a car

#solidstatelife #databases #timeseries

waynerad@diasp.org

"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

danie10@squeet.me

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

Random source code
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

waynerad@diasp.org

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

tord_dellsen@diasp.eu

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