#sqlite

[ follow ]
Java
fromInfoQ
5 days ago

Google Introduces Room 3.0: A Kotlin-First, Async, Multiplatform Persistence Library

Room 3.0 modernizes Android's persistence library, focusing on Kotlin Multiplatform and removing Java code generation for improved development processes.
JavaScript
fromGitHub
4 days ago

GitHub - russellromney/honker: SQLite extension + bindings for Postgres NOTIFY/LISTEN semantics with durable queues, streams, pub/sub, and scheduler

Honker adds Postgres-style NOTIFY/LISTEN semantics to SQLite, enabling durable pub/sub and task queues without client polling or a separate broker.
Python
fromRealpython
5 days ago

SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat Files Quiz - Real Python

The quiz tests understanding of SQLite and SQLAlchemy concepts in Python.
fromTheregister
1 week ago

DuckDB uses RDBMS to tackle lakehouse 'small changes' issue

You make a small change to your table, adding a single row, and it affects data lake performance because, due to the way they work, a new file has to be written that contains one row, and then a bunch of metadata has to be written. This is very inefficient, because formats like Parquet really don't want to store a single row, they want to store a million rows.
Data science
DevOps
fromInfoQ
2 weeks ago

Google Cloud Highlights Ongoing Work on PostgreSQL Core Capabilities

Google Cloud has made significant technical contributions to PostgreSQL, enhancing logical replication, upgrade processes, and system stability.
Software development
fromInfoQ
3 weeks ago

TigerFS Mounts PostgreSQL Databases as a Filesystem for Developers and AI Agents

TigerFS is an experimental filesystem that integrates PostgreSQL, allowing file operations through a standard filesystem interface.
fromInfoWorld
2 weeks ago

Bringing databases and Kubernetes together

Automating Kubernetes workloads with Operators can provide the same level of functionality as DBaaS, while still avoiding lock-in to a specific provider.
DevOps
DevOps
fromInfoQ
3 weeks ago

Replacing Database Sequences at Scale Without Breaking 100+ Services

Validating requirements can simplify complex problems, and embedding sequence generation reduces network calls, enhancing performance and reliability.
Node JS
fromhowtocenterdiv.com
1 month ago

Database Performance Bottlenecks: N+1 Queries, Missing Indexes, and Connection Pools

Database issues, like missing indexes and N+1 queries, are often overlooked in software engineering, leading to persistent performance problems.
Mobile UX
fromGSMArena.com
1 month ago

WhatsApp gets multiple account support on iOS, cross-platform transfer from iOS to Android

WhatsApp introduces new features including dual account support on iPhone, cross-platform chat transfer, and AI tools for enhanced messaging.
fromDjangocentral
1 month ago

How to Perform AND Queries in Django ORM

The simplest way to perform an AND query in Django ORM is by chaining multiple filter() methods. Each subsequent filter narrows down the queryset further by adding an additional condition.
Python
fromRealpython
1 month ago

Understanding CRUD Operations in SQL - Real Python

CRUD operations are essential for creating, reading, updating, and deleting data in applications.
DevOps
fromInfoQ
4 weeks ago

ProxySQL Introduces Multi-Tier Release Strategy With Stable, Innovative, and AI Tracks

ProxySQL 3.0.6 introduces a multi-tier release strategy focusing on stability, innovation, and AI capabilities for diverse user needs.
Angular
fromInfoQ
1 month ago

Mobile Server-Driven UI at Scale

Nubank's mobile platform team manages infrastructure for a digital banking app serving 115 million customers across 40 million daily users, supporting 3,000 engineers developing features in Flutter, iOS, and Android.
Java
fromInfoWorld
1 month ago

9 reasons Java is still great

Java maintains prominence through balancing stability with innovation, community-driven governance via the Java Community Process, and continuous evolution incorporating functional programming, concurrency, and cloud computing advances.
Business intelligence
fromInfoWorld
1 month ago

Why Postgres has won as the de facto database: Today and for the agentic future

Leading enterprises achieve 5x ROI by adopting open source databases like PostgreSQL to unify structured and unstructured data for agentic AI, with 81% of successful enterprises committed to open source strategies.
DevOps
fromInfoQ
1 month ago

AWS Expands Aurora DSQL with Playground, New Tool Integrations, and Driver Connectors

Amazon Aurora DSQL introduces usability enhancements, including a browser-based playground and integrations with popular SQL tools for improved developer experience.
Software development
fromInfoWorld
2 months ago

4 self-contained databases for your apps

XAMPP provides a complete local web stack (MariaDB, Apache, PHP, Mercury SMTP, OpenSSL) while PostgreSQL can be run standalone or embedded via pgserver in Python.
#mysql
fromInfoWorld
2 months ago
Software development

Community push intensifies to free MySQL from Oracle's control amid stagnation fears

fromInfoWorld
2 months ago
Software development

Community push intensifies to free MySQL from Oracle's control amid stagnation fears

#ai
Gadgets
fromZDNET
2 months ago

Disabling this Pixel app could free up to 10GB of storage space - how it works

Disabling AICore on a Pixel phone reclaims up to 10GB of storage, reduces memory and battery use, and stops AI notifications.
Data science
fromInfoWorld
1 month ago

The revenge of SQL: How a 50-year-old language reinvents itself

SQL has experienced a major comeback driven by SQLite in browsers, improved language tools, and PostgreSQL's jsonb type, making it both traditional and exciting for modern development.
fromPaolo Melchiorre
2 months ago

Django ORM Standalone: Querying an existing database

For a long time I wanted to document something I have done many times in production systems but never explained clearly: using Django ORM as a standalone module to connect to an existing database. In my work I have often dealt with legacy systems where the only reliable source of truth was the database itself. In those situations, Django ORM became my Swiss army knife.
Web frameworks
Web development
fromInfoWorld
1 month ago

The browser is your database: Local-first comes of age

Local-first technologies like PGlite and RxDB embed feature-rich databases directly in browsers, enabling instant interactivity while maintaining server synchronization through background sync engines.
fromDbmaestro
5 years ago

5 Pillars of Database Compliance Automation |

There is a growing emphasis on database compliance today due to the stricter enforcement of compliance rules and regulations to safeguard user privacy. For example, GDPR fines can reach £17.5 million or 4% of annual global turnover (the higher of the two applies). Besides the direct monetary implications, companies also need to prioritize compliance to protect their brand reputation and achieve growth.
EU data protection
fromTheregister
1 month ago

Oracle moves to assure MySQL community it really does care

Oracle firmly believes that MySQL's enduring strength arises from this vibrant global community. We are excited to work with the MySQL Community on the strategy we announced in Belgium, January 29, 2026, including adding more features and functionality, accelerating innovation directly in the MySQL core.
Online Community Development
DevOps
fromInfoWorld
1 month ago

Update your databases now to avoid data debt

Multiple major open source databases reach end-of-life in 2026, requiring teams to plan upgrades and migrations to avoid security risks and higher costs.
#mariadb-acquisition
Business intelligence
fromInfoWorld
1 month ago

MariaDB taps GridGain to keep pace with AI-driven data demands

MariaDB's acquisition of GridGain aims to create an integrated platform combining relational database reliability with in-memory computing speed to compete with hyperscaler offerings.
Business intelligence
fromInfoWorld
1 month ago

MariaDB taps GridGain to keep pace with AI-driven data demands

MariaDB's acquisition of GridGain aims to create an integrated platform combining relational database reliability with in-memory computing speed to compete with hyperscaler offerings.
fromInfoQ
2 months ago

VillageSQL Launches as an Extension-Focused MySQL Fork

A new open-source project, VillageSQL, has been introduced as a tracking fork of MySQL aimed at expanding extensibility and addressing feature gaps increasingly relevant to AI and agent-based workloads. Announced by founder Dominic Preuss, VillageSQL Server for MySQL is positioned as a drop-in replacement that maintains compatibility with upstream MySQL while adding a structured extension framework. The alpha release is now available for experimentation.
Software development
Mobile UX
fromBusiness Matters
2 months ago

Why Users Prefer Apps Over Browsers for Daily Digital Tasks

Mobile apps have become the primary interface for daily digital tasks, prioritizing convenience, continuity, and efficiency over the openness of the traditional web.
Django
fromRealpython
1 month ago

Introduction to Python SQL Libraries Quiz - Real Python

A 9-question interactive quiz assesses proficiency in Python SQL libraries for database connectivity, query execution, and cross-database scripting with SQLite, MySQL, and PostgreSQL.
Tech industry
fromInfoQ
2 months ago

Google Introduces Managed Connection Pooling for AlloyDB

AlloyDB's managed connection pooling increases client connections and transactional throughput while reducing operational burden and latency for high-concurrency and serverless workloads.
Python
fromRealpython
2 months ago

TinyDB: A Lightweight JSON Database for Small Projects - Real Python

TinyDB is a lightweight, pure-Python, document-oriented NoSQL database storing JSON documents and offering simple CRUD for small, local, single-process projects.
Mobile UX
fromEngadget
1 month ago

Google begins calling out battery-killing Android apps

Google is implementing warning labels on the Play Store for apps that drain battery through excessive background activity, with gradual rollout beginning March 1.
Java
fromInfoQ
2 months ago

Java Explores Carrier Classes to Extend Data-Oriented Programming Beyond Records

Carrier classes and carrier interfaces generalize record benefits to support flexible, record-like data abstractions without imposing rigid representation rules.
Software development
fromMedium
2 months ago

The Complete Database Scaling Playbook: From 1 to 10,000 Queries Per Second

Database scaling to 10,000 QPS requires staged architectural strategies timed to traffic thresholds to avoid outages or unnecessary cost.
DevOps
fromInfoQ
1 month ago

From Minutes to Seconds: Uber Boosts MySQL Cluster Uptime with Consensus Architecture

Uber redesigned MySQL infrastructure using Group Replication to reduce failover time from minutes to seconds while maintaining strong consistency across thousands of clusters.
fromInfoWorld
2 months ago

The best new features in MariaDB

Ever since version 10.3, MariaDB has been steadily adding Oracle compatibility features, making it easier to port Oracle to MariaDB as-is. Oracle compatibility is opt-in. All you need to do is issue the command SET SQL_MODE='ORACLE' to activate it for a given set of SQL statements. Existing MariaDB behaviors will also be preserved wherever possible.
Software development
fromInfoWorld
3 months ago

What's new in MySQL 9.0

But it still contains useful things and can be upgraded to from MySQL 8.4 LTS; the MySQL Configurator automatically does the upgrade without user intervention during MSI installations on Windows. The major changes include: A new Vector datatype is supported in CREATE and ALTER statements. JavaScript Stored Programs, which support JavaScript-based stored programs and functions, has come to MySQL Enterprise Edition. JavaScript Stored Programs can call SQL, and SQL can call them.
Software development
Software development
fromInfoQ
1 month ago

MySQL 9.6 Changes Foreign Key Constraints and Cascade Handling

MySQL 9.6 moves foreign key constraint and cascade management from InnoDB storage engine to SQL layer, improving CDC pipeline accuracy and data consistency across replication and analytics workloads.
fromInfoQ
2 months ago

Firestore Adds Pipeline Operations with Over 100 New Query Features

Google has overhauled Firestore Enterprise edition's query engine, adding Pipeline operations that let developers chain together multiple query stages for complex aggregations, array operations, and regex matching. The update removes Firestore's longstanding query limitations and makes indexes optional, putting the database on par with other major NoSQL platforms. Pipeline operations work through sequential stages that transform data inside the database.
Software development
Software development
fromMedium
3 months ago

Why Your System Shows Old Data: A Practical Guide to Cache Invalidation

Caching introduces multiple truths; without correct cache invalidation users will receive stale data and silently lose trust.
fromInfoWorld
2 months ago

AI is changing the way we think about databases

Developers have spent the past decade trying to forget databases exist. Not literally, of course. We still store petabytes. But for the average developer, the database became an implementation detail; an essential but staid utility layer we worked hard not to think about. We abstracted it behind object-relational mappers (ORM). We wrapped it in APIs. We stuffed semi-structured objects into columns and told ourselves it was flexible.
Software development
Software development
fromDbmaestro
1 year ago

Why Do You Need Database Version Control?

Database version control tracks schema and code changes, enabling CI/CD integration, collaboration, rollback, and faster, more reliable deployments across multiple databases.
Software development
fromInfoWorld
2 months ago

Why your next microservices should be streaming SQL-driven

Streaming SQL with UDFs, materialized results, and ML/AI integrations enables continuous, stateful processing of event streams for microservices.
Software development
fromDbmaestro
4 years ago

If You Don't Have Database Delivery Automation, Brace Yourself for These 10 Problems |

Manual database processes break DevOps pipelines; only 12% deploy database changes daily, causing configuration drift, frequent errors, slower time-to-market, and reduced productivity.
[ Load more ]