Simplest SQL for Mac?
-
Greetings, I'm looking to create a basic DB for my small media production business. Think content similar to old Northwind DB. Were my partner and I both using Windows, I would just use Access but I use Mac so that is not an option other than using Bootcamp which I would rather not do. I was looking at MySQL and PostgreSQL and not sure which to select. Pros/cons etc. I'm looking to hopefully store the DB online on my web server and create an Objective-C (Cocoa) app or web app (PHP?) to query, insert, update etc. (I know this is DB forums, just giving context). Let me know if clarification is needed. Thank you!
-
Greetings, I'm looking to create a basic DB for my small media production business. Think content similar to old Northwind DB. Were my partner and I both using Windows, I would just use Access but I use Mac so that is not an option other than using Bootcamp which I would rather not do. I was looking at MySQL and PostgreSQL and not sure which to select. Pros/cons etc. I'm looking to hopefully store the DB online on my web server and create an Objective-C (Cocoa) app or web app (PHP?) to query, insert, update etc. (I know this is DB forums, just giving context). Let me know if clarification is needed. Thank you!
There's always Filemaker as a fairly close substitute for Access, having more or less the same drawbacks. So nothing I personally would recommend. If an embedded database is enough for you can check out on this[^] page if SQLite is good enough for you. If you indeed need a "real" database you can read a concise but good comparison between MySQL and PostgreSQL here[^].
Wrong is evil and must be defeated. - Jeff Ello[^]
-
There's always Filemaker as a fairly close substitute for Access, having more or less the same drawbacks. So nothing I personally would recommend. If an embedded database is enough for you can check out on this[^] page if SQLite is good enough for you. If you indeed need a "real" database you can read a concise but good comparison between MySQL and PostgreSQL here[^].
Wrong is evil and must be defeated. - Jeff Ello[^]
Sounds like SQLite will work perfect, plus easy integration with PHP should make my life easy. Thanks a lot!