Published on: 2025-04-22 02:28:31
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables. Now let’s dive into more advanced virtual-table implementations: those that support writes and full transactional behavior. Writes and Transaction Support in Virtual Tables SQLite’s virtual-table interface isn’t read-only. By implementing xUpdate you can expose writable tables over any data source. But true transac
Keywords: sqlite tables transaction virtual xsync
Find related items on AmazonPublished on: 2025-04-22 17:28:31
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables. Now let’s dive into more advanced virtual-table implementations: those that support writes and full transactional behavior. Writes and Transaction Support in Virtual Tables SQLite’s virtual-table interface isn’t read-only. By implementing xUpdate you can expose writable tables over any data source. But true transac
Keywords: sqlite tables transaction virtual xsync
Find related items on AmazonPublished on: 2025-04-24 03:22:17
Rust is fast at runtime — but not so much at compile time. That’s hardly news to anyone who's worked on a serious Rust codebase. There's a whole genre of blog posts dedicated to shaving seconds off cargo build . At Feldera, we let users write SQL to define tables and views. Under the hood, we compile that SQL into Rust code — which is then compiled with rustc to a single binary that incrementally maintains all views as new data streams into tables. We’ve already pulled a lot of tricks in the p
Keywords: i32 rss rust sql time
Find related items on AmazonPublished on: 2025-05-07 10:00:00
Join our daily and weekly newsletters for the latest updates and exclusive content on industry-leading AI coverage. Learn More For decades, the SQL query language has been the cornerstone of database technology. But what happens when you bring SQL together with modern generative AI? That’s the question that Google Cloud is answering as part of a series of database updates rolling out at the company’s Google Cloud Next conference today. Over the past year, all Google Cloud databases have added
Keywords: database google language natural sql
Find related items on AmazonPublished on: 2025-05-07 18:00:15
You might have come across discussions or blog posts suggesting that PostgreSQL's built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions. A notable recent example comes from Neon's blog post, "Performance Benchmark: pg_search on Neon" (link). In their benchmark, Neon compared query performance on their database platform with their pg_search extension (based on Rust's Tantivy library via pgrx ) against the Postgres built-in fullt
Keywords: fts index performance postgresql standard
Find related items on AmazonPublished on: 2025-05-11 23:59:55
Faster interpreters in Go: Catching up with C++ By Vicent Martí | March 20, 2025 The SQL evaluation engine that ships with Vitess, the open-source database that powers PlanetScale, was originally implemented as an AST evaluator that used to operate directly on the SQL AST generated by our parser. Over this past year, we've gradually replaced it with a Virtual Machine which, despite being written natively in Go, performs similarly to the original C++ evaluation code in MySQL. Most remarkably, t
Keywords: 000 ast sql virtual vm
Find related items on AmazonPublished on: 2025-05-12 22:56:37
Sell your stuff. See what sticks. License • Code of Conduct • Contributing Table of Contents Getting Started Prerequisites Before you begin, ensure you have the following installed: Ruby https://www.ruby-lang.org/en/documentation/installation/ Install the version listed in the .ruby-version file Docker & Docker Compose We use docker and docker compose to setup the services for development environment. For MacOS: Grab the docker mac installation from the Docker website For Linux: sud
Keywords: dev docker install mysql use
Find related items on AmazonPublished on: 2025-05-14 09:56:37
Sell your stuff. See what sticks. License • Code of Conduct • Contributing Table of Contents Getting Started Prerequisites Before you begin, ensure you have the following installed: Ruby https://www.ruby-lang.org/en/documentation/installation/ Install the version listed in the .ruby-version file Docker & Docker Compose We use docker and docker compose to setup the services for development environment. For MacOS: Grab the docker mac installation from the Docker website For Linux: sud
Keywords: dev docker install mysql use
Find related items on AmazonPublished on: 2025-05-17 09:07:44
Stop syncing everything Partial replication sounds easy—just sync the data your app needs, right? But choosing an approach is tricky: logical replication precisely tracks every change, complicating strong consistency, while physical replication avoids that complexity but requires syncing every change, even discarded ones. What if your app could combine the simplicity of physical replication with the efficiency of logical replication? That’s the key idea behind Graft, the open-source transaction
Keywords: data edge graft replication sqlite
Find related items on AmazonPublished on: 2025-05-17 19:07:44
Stop syncing everything Partial replication sounds easy—just sync the data your app needs, right? But choosing an approach is tricky: logical replication precisely tracks every change, complicating strong consistency, while physical replication avoids that complexity but requires syncing every change, even discarded ones. What if your app could combine the simplicity of physical replication with the efficiency of logical replication? That’s the key idea behind Graft, the open-source transaction
Keywords: data edge graft replication sqlite
Find related items on AmazonPublished on: 2025-05-23 12:14:36
PostgreSQL Model Context Protocol (PG-MCP) Server A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents. Overview PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture. This implementation builds upon and extends the reference Postgres MCP implementat
Keywords: connection database mcp postgresql server
Find related items on AmazonPublished on: 2025-05-25 17:20:44
Postgres Extension Tutorial Welcome to the Postgres Extension Tutorial. This comprehensive tutorial is designed to provide a step-by-step guide to PostgreSQL extension development. Whether you're new to PostgreSQL or extension development, this tutorial assumes only a basic knowledge of Postgres and the target programming language. It covers various aspects of creating, managing, and distributing extensions for PostgreSQL. After completing this tutorial, you'll have a strong foundation in Post
Keywords: development extension postgres postgresql tutorial
Find related items on AmazonPublished on: 2025-06-04 01:18:39
MySQL transactions per second vs fsyncs per second Jul 2020 Just wondering how many transactions or writes per second MySQL can handle? While it depends on many factors, fundamentally, about as many transactions as MySQL can commit to disk per second. A modern disk can do ~1000 fsyncs per second, but MySQL will group multiple writes with each fsync. An okay rule-of-thumb would be 5000-15,000 writes per second, depending on things like writes per transaction, number of indexes, hardware, size o
Keywords: fd fsync fsyncs mysql second
Find related items on AmazonPublished on: 2025-06-06 07:15:41
Copyright © 2025 GizmoData LLC - All Rights Reserved Description This is the GizmoSQL public repo - used to provide info and artifact downloads for GizmoSQL - an Apache Arrow Flight SQL server implementation using DuckDB or SQLite as a backend database. It enables authentication via middleware and allows for encrypted connections to the database via TLS. For more information about Apache Arrow Flight SQL - please see this article. Note GizmoSQL is a licensed-product - you MUST have a valid
Keywords: gizmosql run server set sql
Find related items on AmazonPublished on: 2025-06-24 03:59:04
TLDR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases. What’s more, all compute is within Postgres, and all tables are managed directly by PostgreSQL—it’s not a simple wrapper. This is the story of pg_mooncake. What Is ClickBench? ClickBench is the definitive benchmark for real-time analytics databases, originally designed to showcase the performance of ClickHouse. It evaluates databases on
Keywords: analytics databases execution postgres postgresql
Find related items on AmazonPublished on: 2025-07-05 23:29:12
SQLite-on-the-Server Is Misunderstood: Better At Hyper-Scale Than Micro-Scale We're Rivet, a new open-source, self-hostable serverless platform. We've been in the weeds with SQLite-on-the-server recently and – boy – do we have a lot of thoughts to share. Give us a star on GitHub, we'll be sharing a lot more about SQLite soon! There's been a lot of discussion recently about the pros and cons of SQLite on the server. After reading many of these conversations, I realized that my perspective on th
Keywords: database databases partition scale sqlite
Find related items on AmazonPublished on: 2025-07-07 15:29:12
SQLite-on-the-Server Is Misunderstood: Better At Hyper-Scale Than Micro-Scale We're Rivet, a new open-source, self-hostable serverless platform. We've been in the weeds with SQLite-on-the-server recently and – boy – do we have a lot of thoughts to share. Give us a star on GitHub, we'll be sharing a lot more about SQLite soon! There's been a lot of discussion recently about the pros and cons of SQLite on the server. After reading many of these conversations, I realized that my perspective on th
Keywords: database databases partition scale sqlite
Find related items on AmazonPublished on: 2025-07-08 03:14:22
What’s New The Internals of PostgreSQL PostgreSQL is a well-designed, open-source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works cooperatively with each other. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity make it difficult. The main purposes of th
Keywords: author content document postgresql use
Find related items on AmazonPublished on: 2025-07-08 14:10:23
We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 scoring and ranking right into PostgreSQL, making your searches smarter and faster. What’s New? BM25 Scoring & Ranking : Get more precise and relevant search results with BM25, helping you find what matters most. Optimized Indexing : Thanks to the Blo
Keywords: bm25 documents elasticsearch postgresql text
Find related items on AmazonPublished on: 2025-07-16 02:47:06
Check out the discussion of this post on Hacker News. We have news! EdgeDB is rebranding as Gel, more on that below. Let's talk about something else first. Something fascinating has been happening recently. PostgreSQL seems to be quietly eating the database world. It's not just topping the charts, its adoption momentum is accelerating. What's going on? The answer is right there in the PostgreSQL.org's tagline: The World's Most Advanced Open Source Relational Database It's not just an empty
Keywords: database gel just postgres postgresql
Find related items on AmazonPublished on: 2025-07-16 02:47:06
We have news! EdgeDB is rebranding as Gel, more on that below. Let's talk about something else first. Something fascinating has been happening recently. PostgreSQL seems to be quietly eating the database world. It's not just topping the charts, its adoption momentum is accelerating. What's going on? The answer is right there in the PostgreSQL.org's tagline: The World's Most Advanced Open Source Relational Database It's not just an empty marketing boast. It's meaningful. Let's unpack, startin
Keywords: database gel just postgres postgresql
Find related items on AmazonGo K’awiil is a project by nerdhub.co that curates technology news from a variety of trusted sources. We built this site because, although news aggregation is incredibly useful, many platforms are cluttered with intrusive ads and heavy JavaScript that can make mobile browsing a hassle. By hand-selecting our favorite tech news outlets, we’ve created a cleaner, more mobile-friendly experience.
Your privacy is important to us. Go K’awiil does not use analytics tools such as Facebook Pixel or Google Analytics. The only tracking occurs through affiliate links to amazon.com, which are tagged with our Amazon affiliate code, helping us earn a small commission.
We are not currently offering ad space. However, if you’re interested in advertising with us, please get in touch at [email protected] and we’ll be happy to review your submission.