I am planning to make a app of database of a particular animal (what it eats, where it lives, ...).
. How can I create an app that has a database?
. Is there a software I add to my app?
. Do I design it in another software and then convert it to swift?
. Or is there instructions of how to design a database app in swift?
Thank you so much.
I personally think the best library right now would be fmdb, wrapped around sqlite:
This is probably one of the more mature libraries, and isn't too bad to get used to if you are familiar working in other frameworks.
Previously, database apps were kind of hacked, you'd dump data into a Json file, and another language like php would pick up that data and push to a database using normal methods. An example of this was taught here:
http://codewithchris.com/iphone-app-connect-to-mysql-database/
I've used similar methods for desktop apps, but now other libraries are being designed to serve this purpose. Here's one that actually does pretty well, even though it's meant for mobile use specifically, can be used for desktop use as well:
https://realm.io/docs/swift/latest/
A lot of these are still very young and have yet to mature into something that is usable long term, but is enough to get started with.
Thank you!
For many use cases, although not technically a RDBMS as such, there is Core Data built right into Xcode. It's build on SQLite, has a mature API and a great visual editor to build model objects and relationships.
Saying this, in my view, I would not class Core Data as a beginners framework, but if you're fairly comfortable programming iOS / macOS, then there is a lot to be said for it.
I've developed databases in MySQL Workbench and ported them to CloudKit, SQLite, and Swift. I've created some workbench modules with Python to do so. They're available if anybody is interested.
https://github.com/JoelHz/FromMySQLWorkbenchToCloudkit/blob/main/pythonTranslateMySQLWbToCloudki https://github.com/JoelHz/FromMySQLWorkbenchToSwift/blob/main/pythonTransMySQLToSwift https://github.com/JoelHz/MySQLWorkbenchPluginToSQLite/blob/main/tosqliteformat_grt.py