PostgreSQL compatibility

• Tables no longer create a sequence automatically when no primary key is specified.
• Primary keys are now always required. This is a first step to adding support for SERIAL and BIGSERIAL.
• Support postgres-style parameters $1, $2, $30, etc.
• Removed support for SQLite-style parameters $?
• Support standard quotes for string literals and identifiers
• Renamed SOUBLE to DOUBLE PRECISION
• Renamed BLOB to BYTEA
• BOOL type now behaves like in Postgres
• Support nextval expression
• Add support for :: casts

Misc

• Use Pebble v2.1.0
• Fix prepared statements
• Improve boolean and integer comparison

Full Changelog: v0.17.0...v0.18.0

ChaiSQL has dropped object/document support to focus on Postgres compatibility.
v0.17 is the first step towards that goal and comes with a lot of API changes.
There are still quite a few features that need to be renamed / modified / reimplemented to be Postgres compatible but we're getting there.

API changes

• Drop document / object / array support
• Drop chai.Open API, database/sql is not the only supported API
• Use Pebble v2
• Add BIGINT type

New Contributors

• @samjewell made their first contribution in #532
• @kylebrandt made their first contribution in #531

Full Changelog: v0.16.1...v0.17.0

What's Changed

• Change carbon to new package path by @kenshaw
  in #539
• refactor: Use carbon to simplify code by @kuafuRace in #540
• Bump pebble by @cgruber in #541

New Contributors

• @kuafuRace made their first contribution in #540
• @cgruber made their first contribution in #541

Full Changelog: v0.16.0...v0.16.1

Genji is now ChaiSQL ! 🫖

A name change that comes with a change in objectives: ChaiSQL strives to become a modern SQL embedded database.
The goal is to follow the SQL standard as much as possible, without sacrificing schema flexibility.

⚠️ The on-disk format has changed quite a bit and is not compatible with databases created prior v0.16.0.
ChaiSQL is under heavy development and breaking changes can still happen, though the on-disk format should be mostly stable from now on.

API changes

• Support for DESC composite primary keys and indices
• Add TIMESTAMP type
• The DOCUMENT type is now OBJECT

Other notable changes

• StructScan check interface parameter is a pointer to a struct by @abramlab in #487
• Add LOWER builtin function by @agonist in #510
• Add UPPER function by @agonist in #511
• add trim, ltrim, rtrim functions by @agonist in #512
• Add coalesce function by @yaziine in #513
• Add random function by @agonist in #514

New Contributors

• @agonist made their first contribution in #510
• @abramlab made their first contribution in #487

Full Changelog: v0.15.3...v0.16.0