Best Database

Portal Home > Knowledgebase > Articles Database > Best Database

Posted by freebroch1, 12-11-2010, 03:58 PM
Hi, Can u please suggest which is the best database for accounting software? Thanx
Posted by bsolaris, 12-11-2010, 04:22 PM
I don't think there is such a thing as best database. What is the best car? It's entirely subjective to personal preferences and depending upon the scope of the job. Most likely Oracle though if you can afford it. But that probabally wasn't the answer you were looking for.
Posted by bitwisehost, 12-15-2010, 01:52 PM
Are you creating accounting software? Do you need a back end for already built accounting software? Is it web based? I would have to agree with bsolaris about Oracle but it is expensive. Something to think about would be how much number crunching will the db be doing. or will it just be storing data.
Posted by ramnet, 12-16-2010, 04:35 PM
If you're writing software I'd suggest using a database abstraction library so that you aren't tied to any certain database system.
Posted by mcfc4eva, 12-16-2010, 09:18 PM
Sage Accounts is renowned as one of the market leaders. However, as bsolaris rightly pointed out - it depends on several factors including personal preference and task requirements! I've used sage accounts and although it require patience and a little research/training I can certainly attest to it being a well designed solution
Posted by cvefa, 01-28-2011, 06:29 PM
my answer personel dont use myisam table type must be use mysql innodb and php simple is the best
Posted by johnston981, 01-30-2011, 02:50 PM
I think you can find any database from sites like sulekha.com, justdial.com etc sites. You can shortlist category wise data from these sites.
Posted by pmwebster, 02-02-2011, 12:04 AM
If you plan on using this long term, I'd recommend using postgres. The future of mysql (as much as I love using it) is pretty shaky at the moment. If its just a personal project and you don't plan on ever updating the database daemon, mysql appears to have much less of a learning curve for most users. Keep in mind that using any single file database like couchdb is neat, but if you're talking about thousands of records, you'll want something with more horse power.
Posted by csparks, 02-02-2011, 12:45 AM
MyISAM has its place, as does INNODB, but I do not think that is what the OP is asking. OP, please clarify what you are doing, and you will get much more useful answers. If you are designing a personal accounting system, more then likely mysql will be fine (given you are not building it for you personal multi-billion dollar enterprise, but if this was the case, I would suspect you would not be asking in a forum, and would have a consultant team and programming team )
Posted by praveenkv1988, 02-02-2011, 03:21 AM
Use INNODB on MySQL.
Posted by Angelo, 02-02-2011, 12:34 PM
If you are on budget and looking for a scalable solid solution, PostgreSQL is the way to go.
Posted by technoguff, 02-02-2011, 12:41 PM
yeah there is no certain answer to this kind of question. it depends on what you are building.
Posted by benjohnsonfs, 02-04-2011, 01:41 PM
If open source database is required ? MySQL else Oracle.
Posted by coderiser, 02-04-2011, 04:51 PM
my vote is for mysql
Posted by darhost_sell, 02-04-2011, 05:04 PM
Mysql is the best database software
Posted by tylerdu, 02-04-2011, 08:32 PM
MySQL is the most popular, but PostgreSQL is the best open source database.
Posted by cselzer, 02-04-2011, 10:15 PM
How can say any database is the best? They all have their ups and downs and uses... mysql is just popular because its easily learned because of its lack of features. I'd agree because postgresql is all i use myself as far as a RDBMS, I do enjoy using sqlite as well which is a whole new topic imo. As far as accounting software, oracle hands down. I'd prefer enterprise grade software being used for accounting software than anything else. I've used oracle a little bit, not a whole lot, but the features it it has is just incredibly more superior compared to mysql.. parallel queries, virtual private database, database links, queues, materialized views, flashback, data miner, snapshots, fine grained audit, database level triggers, table partitioning, table spaces, any many many more.
Posted by ayna, 02-09-2011, 07:21 AM
I like Mysql and Oracle Database.