Mac OS 9 Discussion > Development & Programming

Embedded database recommendations?

(1/1)

cluster_fsck:
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!

cluster_fsck:
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!

Jubadub:

--- Quote from: 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!

--- End quote ---

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! :)

sentient06:
I have a stupid question: what is Valentina?

Jubadub:

--- Quote from: sentient06 on December 05, 2024, 07:27:19 AM ---I have a stupid question: what is Valentina?

--- End quote ---

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

Navigation

[0] Message Index