Local database using schema

Question

I want to build a local database for my program, which should be populated using user settings, search websites, etc.

But what I could find on the Internet (google and this site) is just a database from a server or local database with specific dialects, an exclusive racket, which is the most popular of all dialects of the scheme.

Here is the information from the racket documentation for the database:

Web applications in the schema

Using a database connection

As far as I can see, there is no information or no example about using a local racket database.

Can someone give a small example for building and using a local database with a racket?

Answer 1

SQLite uses local database files:

(require db) (define c (sqlite3-connect #:database "path/to/db-file" #:mode 'create) 

The dack docs docket assumes that you already know how to use the database system, so read the SQLite docs first. Then read the dack docs docket to find out how to send SQL commands to the SQLite database.