Which database software should be used for home project use?
I usually use SQL server management at work but looking for more suggestion so i can install on my new laptop.
Re: Database Software for Development
Checkout sqldeveloper ( my current fav. ) and Toad ( not sure if it is free ). If it is the database you are asking about, I would go with MySQL.
Re: Database Software for Development
what do you mean database software ? Are you referring to the database server or the client ?
If you are looking for a server for your perosnal project, then i would suggest MySQL. Its very lightweight. Plus it comes with its own GUI client (which is not a memory hog like sqldeveloper or Toad) which you can use to run your day-to-day queries. Plus most of the cDatabase server are fork from Mysql. so you will get familiar with lots of new databases not just one.
That being said, The world is already moving to the cloud. Not sure what purpose you will be using this database for or if there are ny future of your project, but if there is then try to search for BaaS on Google. My favorite one would be Parse … it provides you REST API which you can use to persist your data and also have “push functionality” (if needed). and if your project is an a cell phone app then it would be the best choice over any database server installed locally.
Edit:
a good comparison for you List of the best Android Backend as a Service (BaaS) provider - AndroidBegin
Re: Database Software for Development
Database server and i don’t need for mobile apps. It is for personal project, looks like I would i have to follow MYSQL.
Re: Database Software for Development
I would like to make the case for postgreSQL. It is one of the most powerful databases and also has a gui called pgadminIII.
Re: Database Software for Development
I would suggest mysql considering all price/license etc. assuming you wouldnt be in a position to spend a lot in home project. Not sure about postgres.
Btw sqldeveloper isnt a database rather just a client tool to connect to a DB, so is toad.
Re: Database Software for Development
Postgresql is an open source database.
Database Software for Development
I've used Ingres as well which was owned by my previous company but now an open source. It's okish, more old school db
Re: Database Software for Development
If you wanna play with something then play with something new i.e. NoSQL databases. You can install your own copy (Install MongoDB on Windows ? MongoDB Manual 3.0) or you can just get a free instance at MongoLab (https://mongolab.com/).
If you are just looking for something to persist data then their are plenty of embedded databases available. i.e. NeDB.