Mac OS 9 Lives

Mac OS 9 Discussion => Development & Programming => Topic started by: cluster_fsck on December 01, 2024, 06:13:53 AM

Title: Embedded database recommendations?
Post by: cluster_fsck on December 01, 2024, 06:13:53 AM
Hey folks - I’m developing a little app for my own pleasure/learning and am in need of an embedded database. Modern macOS has SQLite and CoreData/SwiftData, and I’m looking for something similar for retro development. My use case is for a persistent cache to reduce server round trips so I can cache slow changing data like a user’s avatar image locally. I’m developing in C on CodeWarrior and am targeting more “modern” of the classic Mac OS lineage as enhancements like the Carbon Event model make development so much easier (if I ever distribute the software it’ll require CarbonLib and could likely be run on 8.5+).

Anyway, using the file system will likely be too slow and I wanted something that would let do cache-like things in terms of evicting items older than x to keep the size reasonable and allow me to not store everything in memory. If you have any pointers to source code packages I’d appreciate it!
Title: Re: Embedded database recommendations?
Post by: cluster_fsck on December 01, 2024, 08:25:22 AM
Looks like I answered my own question! I remembered that Valentina existed and their site still hosts the older SDK for classic and Carbon-based development. Going to give this a try and see how it goes!
Title: Re: Embedded database recommendations?
Post by: Jubadub on December 01, 2024, 09:07:44 AM
Looks like I answered my own question! I remembered that Valentina existed and their site still hosts the older SDK for classic and Carbon-based development. Going to give this a try and see how it goes!

This? http://valentina-db.com/download/prev_releases/1.11/

This seems pretty cool. Never heard of it before. Please do share your experiences/efforts with this, to give more of us incentive to develop as well! :)
Title: Re: Embedded database recommendations?
Post by: sentient06 on December 05, 2024, 07:27:19 AM
I have a stupid question: what is Valentina?
Title: Re: Embedded database recommendations?
Post by: Jubadub on December 05, 2024, 09:56:15 AM
I have a stupid question: what is Valentina?

A database system. See the Garden page for it for some nice screenshots to give you a better idea: http://macintoshgarden.org/apps/valentina