A study found that using a knowledge graph with SPARQL for AI agent memory queries resulted in higher accuracy compared to SQL. The choice between SQL and SPARQL should be based on personal experiments and specific needs.
Related articles
See all- Insight for DBAs
How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server
A tool that can extract data from raw database files without a running server is highly beneficial for database administrators. It allows offline data extraction from InnoDB, MyISAM, and MyRocks files, useful when the server is unavailable or for quick data recovery.
- ChromaDB
ChromaDB: Embeddings and Vector Databases in Python
Real Python introduces embeddings and vector databases with ChromaDB, explaining how relevant documents can provide context for LLMs. The supplied excerpt covers vector fundamentals and NumPy operations; the tutorial targets ChromaDB 1.5 and Python 3.12+.
- Valkey
Testing without a server: using FakeValkey, the in-memory test double for Valkey
FakeValkey acts as an in-memory test double for Valkey, allowing developers to conduct tests without a real server. It simulates server behavior within the test process, providing a fast and efficient testing environment.
- DuckDB
Gems of DuckDB 2.0.0
DuckDB 2.0.0 introduces major features like the Quack protocol and asynchronous I/O, along with many usability improvements such as a Python appender for efficient data insertion and enhanced CLI commands. For full details, visit the "What's New in the Docs for 2.0" page.
- PostgreSQL
semab tariq: Your backups are green. That does not mean you can restore.
Many teams trust their backup dashboards, but face serious issues when they need to restore data. The article explores this gap between having backups and being able to recover them, a common problem in PostgreSQL environments.
- PostgreSQL
Vadim Yatsenko: Commit Sequence Number (CSN) MVCC: Lock-Free Snapshot Acquisition
CSN MVCC in PostgreSQL enhances performance by enabling lock-free snapshot acquisition, improving the efficiency of determining row visibility for queries.