A simple Win32 console program with example procs to manipulate a SQLite3 database.

I plan to do a GUI database program as my next project using SQLite3.

What type of database program you all can suggest to me? Maybe simple one. But I don't want do address book as I have done it before using HLL as hobby project.
Of course I also have done Point-Of-Sale system but that was complex database program not suitable to develop using Assembly language.

If I understand correctly, I tried OP example before in post #1, SQLite3 database in his example is file-based.

"not suitable to develop using Assembly language"
Interesting, inside of all the Point-Of-Sale systems on the planet --- there is only Assembler!
Happy Easter, everyone!

What about TODO? A task scheduler with tracking deadlines and a reminder.

Apparently, according to WinRAR your file win32sqlite.res has been compressed into 0 bytes, which is according to information theory is impossible

I am more into CRUD... Anyway, I will keep your suggestion in mind. Thanks.

Please make a DB Engine which is not based on tables --- I mean not SQL based.
Every object in the database shall have the following fields:

- Type (integer value)
- Identifier (integer value, unique across the database)
- Name (text of some length, say, 128 characters)
- Storage (can be an offset into a large file plus length of the stored data)

Now, the data inside the storage would be a set of NAME=VALUE pairs, describing the properties of the object.
VALUE is always text, can be a path to an image or other data files.
It can be a descriptor of more elaborate nature: "go to file xxxx, seek to offset xxxx and load xxxx bytes".
Anything can be encoded into text.

The database shall have API to be able to:

- Enumerate objects of same type (return a set of their ID values)
- Find the object(s) by name (using wildcards too)
- Load the objects NAME=VALUE data and find the objects matching some conditions
- Should be able to change VALUE for a NAME
- Should be able to add/remove properties
- Of course, add/remove whole objects using their ID values or names.

I afraid it is more than what I am capable of.

I am here to learn Windows GUI programming and to learn database programming using Assembly language.

I have other projects currently keep in view, like an SDL2 / SDL3 game (based on Tomasz's example), and a NES emulator (or 6502 disassembler).

Not that I am not interested in doing a DB engine, but my past failures show that I don't have the talent to become a pioneer in anything.

ADD: Sometimes when I set the goal too high, I will start procrastinate.

MongoDB (git)

just do stuff for sake of learning, be it an algorithm, system API, library API; those tiny stuff from different areas can be made modules into larger project.

Yeah and even if you abandon the project at some point, your knowledge remains, which will prove useful later even if it doesn't right now.