great.db v3.0.0

v3.0.0 brings some big changes

New

1. Now supports bun, deno and node.js using runtimey.
2. Added deleteTable() to delete tables from the database.
3. Added pragma() -> .get()/.set() to edit or fetch pragma values.
4. Added getSqliteVersion() to fetch the version of SQLite being used by the underlying library.
5. table#filter() now supports both fetching and deleting data.
6. New logos and artwork for the README.md.

Breaking

1. GreatDB.Type.Disk has been renamed to GreatDB.Type.File.
2. GreatDB.Type.File requires filename property with name of database file along with the extension.
3. table#get() now returns result or null only.
4. table#set() now accepts multiple objects as parameter instead of an array of objects.
5. table#fetch() now requires a paramter of "Select" or "Delete" instead of using Select by default.

Bugfixes

1. Uses join() from node:path to join the paths improving compatibility in new GreatDB.Database.

great.db v2.3.0

1. New serialize, backup and clone functions for GreatDB.Database. Check out the docs to learn more about it.
2. Added new Type.Serialized to support opening of serialized database.
3. Improved and simplified internal runtime detection.
4. Updated docs for new api.
5. Added tests for few functions. Can be run using bun run test.
6. Bumped bun-types to v0.2.2.

great.db v2.2.0

1. Added executeQuery function to run SQL code directly. Learn more.
2. Added new pattern field to filter function to support SQL LIKE.
3. Database#close function is now asynchronous.
4. Added a new live shell to execute SQL code in a shell based environment on an in-memory database (run bun run shell to try it).
5. Internal refactor of type inference.
6. Updated docs for the above changes.

great.db v2.1.0

• Added filter function for advanced queries.
• Updated examples
• Added a new example for filter
• get() now supports fetchAll parameter

great.db v2.0.0

v2 brings some big changes to great.db

• great.db now works both with node.js and bun using better-sqlite3 and bun:sqlite respectively
• Schemas now can only be created through DataType imported from great.db
• 3 new datatypes are added - AutoIncrement, Buffer, Uint8Array
• Typescript types are now automagically inferred from the schema created using DataType
• Some internal code refactors to maintain cross-compatibility between both libraries
• table#set() now also supports array of inputs
• Improved examples to support the new API
• Improved README.md, DOCUMENTATION.md
• Removed db readonly feature temporarily
• Bump bun-types to 0.1.11

great.db v1.0.0

Initial release.