Technical journal
The QoreDB Blog
Insights, tutorials, and news about QoreDB and modern development.
81
matching articles
Explore
Latest articles
81 articles
Virtual Relations: defining FKs where the database has none
Not all databases declare their relations. MongoDB collections have no notion of a foreign key. SQL…
How QoreDB handles query cancellation depending on the engine
Cancelling a long-running query is a routine operation for a database client, but how it is carried out…
QoreDB's Query Library: organizing your queries with folders and tags
After a few weeks of using a database client, you accumulate useful queries. The SELECT that joins three…
The SQL Server Driver in QoreDB: Tiberius, the bb8 Pool, and OFFSET/FETCH Pagination
SQL Server remains one of the most widely deployed engines in the enterprise. Integrating it into a…
The CockroachDB driver in QoreDB: PostgreSQL compatibility done right
CockroachDB is a distributed SQL database that implements PostgreSQL's wire protocol. For a database…
The Background Job Manager: Long Exports and Asynchronous Tasks
Exporting five million rows to CSV, launching a pg_dump backup, aggregating a MongoDB stream through a…
QoreDB's Security Model: Threats and Countermeasures
Many discussions about the security of a database client start from the model of an online service, with…
Automatic secret redaction in QoreDB
A database client constantly handles information that should never be copied anywhere else: connection…
QoreDB's Sandbox Mode: Testing Changes Without Touching the Database
Testing a change on a database before committing it is a routine part of a developer's day, yet it's…