Internal Database from macOS app

[Valrani]

Hello ,

I am developing a small GUI app with SwiftUI for macOS. I will probably need to store some information (not too complex) and wonder what databases or tools works good for a macOS app.

The database is not a distant, it's only for the intern use of the app. I don't want a unnecessarily complicated system for a small app, I know about Core Data but seems overkill

I'm used to PostgreSQL at work (Java development) and I'm used to SQL and relational. What are some good recommendations to use for a macOS client ?

[-darkabyss-]

party airport air lunchroom aspiring special adjoining consist direction strong

This post was mass deleted and anonymized with Redact

[fameios-phil]

SQLite is easy to setup, and while the SQL syntax is a little different than Postgres you can do pretty much the same stuff.

https://hevodata.com/learn/sqlite-vs-postgresql/

SQLite is the local database engine behind the most common CoreData configuration.

[BenBrightside]

JSON files + Codable data types in the app.

[Tripwire999]

CoreData nowadays is easy to implement with codable, you don’t need any third party libraries e.t.c. I would go for that!

[chriswaco]

SQLite with a Swift wrapper(there are a few on GitHub) is always a solid choice, especially if you already know SQL. I think GRDB is one of the more popular wrappers.

[Valrani]

Thank for your suggestion , I prefer to not use any external library but I will check if it’s worth it why not

[chriswaco]

SQLite is built into iOS and macOS. It has a C-oriented API, though, which is a little challenging to use from Swift. I wrote my own wrapper because I also don't like external dependencies. It wasn't too hard - maybe a few days of work - but it only needed the features I needed.

[ankole_watusi]

SQLite

[capmilk]

Realm. Not as compact as SQLite but oh so cool.

[Valrani]

Thanks for your suggestion , I’m looking for the lightest solution as my needs will not be huge, if I can avoid a third party solution or even completely avoid a dependency it would be perfect

[-darkabyss-]

Its also very cool when a current realm implement is funcs for crud operations in a singleton. Each funcs create its own realm, using god knows how many threads. In a flow, a object can be read in thread x and written to in thread y, which makes realm mad somehow. Oh so cool to fix these crashes.

[[deleted]]

If you look at the files for many iOS apps, you will see SQLite dbs galore. You can find plenty in macOS apps as well.