Recreational Relational Databases

[citationneeded]

Does anyone here make databases for personal projects--like organizing your finances or collections? If you do, do you use MySQL, Access, or something else?

I am most knowledgeable in Access but looking to branch out to something more powerful.

[ChristopherL]

I think the bigest problem you'll find is that mysql etc do not provide an interface.

With Access you can create the database and interface in one shot.

But with say Mysql you will need some mechanism to access the data, something like php or Java.

[HackerX]

Does anyone here make databases for personal projects--like organizing your finances or collections? If you do, do you use MySQL, Access, or something else?

I am most knowledgeable in Access but looking to branch out to something more powerful.

Why? Access is probably perfect for what you want. If you really wanted more powerful then you could go Sql Server + Access but I would really question why you think you needed "powerful" for a personal collection.

If I needed a personal SQL db for a project though, I'd personally probably look into SQLite to saving having to install a separate db engine.

[mplogue]

I've yet to find a project big enough to require expansion from Access. But that would be indicitive as to the scale of my data sets. However, if I did need to upsize the back end, I would still probably utilize Access as the front end, or set up a web-based interface (depending on the number of users).

If I were looking for a new skill, I would look at learning how to build web applications - which can be tied to pretty much any db system backend.

[citationneeded]

I would really question why you think you needed "powerful" for a personal collection.

Sorry for not clarifying. Powerful was not the best word, and neither is robust. I learned Access when I was using Windows. Now that I use Ubuntu, I taught myself mySQL, but am really inquiring to see what others' preferences are and what might be best to focus on next.


If I were looking for a new skill, I would look at learning how to build web applications - which can be tied to pretty much any db system backend.

Thanks! I guess this means teaching myself about LAMP configurations?

[HackerX]

Postgres > MySQL

(imo).

[void]

Postgres > MySQL

(imo).

And in the opinions of a large number of professionals. Why just a few days ago there was a huge thread (To view links or images in this forum your post count must be 2 or greater. You currently have 0 posts.) over at the Arstechnica forums detailing why PostgreSQL > MySQL. In summary, MySQL is an horrific atrocity that is popular for reasons unknown.

[HackerX]

And in the opinions of a large number of professionals. Why just a few days ago there was a huge thread (To view links or images in this forum your post count must be 2 or greater. You currently have 0 posts.) over at the Arstechnica forums detailing why PostgreSQL > MySQL. In summary, MySQL is an horrific atrocity that is popular for reasons unknown.

Pretty much.

MySQL got there first, is my best guess.


As for learning more powerful databases, I have this suggestion: FFS learn what an index is and how to use them.

[sombragris]

Perhaps you might find Tellico (To view links or images in this forum your post count must be 2 or greater. You currently have 0 posts.) convenient.