what is the best database software for you?
please indicate why and where could it be much useful than other database softwares released.
please indicate why and where could it be much useful than other database softwares released.
9-08-2008
please indicate why and where could it be much useful than other database softwares released.
11 Comments
RSS feed for comments on this post.
Sorry, the comment form is closed at this time.
i use mysql… good thing about it.. its free and with phpmyadmin its very easy to use/setup and support in almost every web language makes it easy to integrate into web applications and websites
Comment by Brady — 9-08-2008 @ 10:14
Microsoft Access: it not that hard to use but it will cost you a pretty penny, there is also OpenOffice Database, but is isn’t great if you’re used to Access (Free)
Comment by fevbstsith — 9-08-2008 @ 15:01
ms access or mysql
well ms access almost everyone have it and mysql is for web server so this 2 alway the top!!!
Comment by Ghost — 12-08-2008 @ 14:17
Depends on your needs.
I like Excel which is primarily for spreadsheets, but I keep a membership datafile where we can record addresses (for mailing labels), and keep track of the completion of requirements. I also use it to merge with Word documents - letters, labels, and catalogs (for a specialized list). This will describe Excel more fully.
A business might prefer Access which is a powerful database program from MS. Go to this link for a detailed description.
If you are looking for a freebie, you can download open office which is comparable to MS Office.
Free OpenOffice – Word Processing Comparable to MS Word
download at:
tutorial at:
Calc — a spreadsheet similar to Microsoft Excel with a roughly equivalent range of features. Calc provides a number of features not present in Excel, including a system which automatically defines series for graphing, based on the layout of the user’s data. Calc is also capable of writing spreadsheets directly as a PDF file.
Comment by TheHumbleOne — 15-08-2008 @ 18:15
I just love these answers reading about all the info that these very computer literate people know. I am just a novice myself
Comment by rrita k — 16-08-2008 @ 10:06
There’s no best or worse database software. There’s just one for each need.
The main factor to have in mind when choosing engine is the database size. I will list engines from smaller to bigger (IMHO).
> Excel - OpenOffice Calc
Well, it is not a database engine, it is just a spreadsheet.
> Jet (access) - Open Office Base
Basic implementation of database techniques and algorithms. Useful for personal, home and small business applications. No SQL knowledge needed, and you can make a front-end application as part of the database file.
> MySQL (community edition) - Sybase - DB2 - Informix
Professional database engines. SQL knowledge required. For small business to large companies that dont require lots of querying like a supermarket with hundreds of POS, an executive board requiring real time statistics and DBAs modifying information. It fits perfectly for websites, inventory, warehouses, supermarkets with dozens of POS…
MS SQL - Oracle - MySQL (enterprise edition)
Professional database engines. SQL knowledge required.
For small business to large companies that do require lots of querying like a supermarket with hundreds of POS, an executive board requiring real time statistics and DBAs modifying information. Full text search capabilities. They’re not cheap. People using those databases are NASDAQ, Fujifilm, Cingular, Telefonica (spain and LatAm)…
Comment by Braiam — 18-08-2008 @ 5:51
the term database means different things to different people. for many many years, in the world of xBase (dBase, FoxPro, CA-Cliper), database was used to describe a collection of fields and records. in access terms, a database is a collection of objects that make up a complete system. the main objects include tables, queries, forms, reports, macros, and modules and each has its own special function. the access environment also consists of several additional features, which include relationships, toolbars, menus, database properties and import/export specifications. together, all these objects enable our to create powerful, user-friendly, integrated applications. an access application contains all the queries, forms, reports and macros necessary to display the date in a meaningful way and update it as necessary. a self-contained, single-user access application also includes tables in the application database. a multi-user access application usually consists of two database files one housing the tables and the other containing the objects that access the data.
Comment by ourida a — 19-08-2008 @ 22:50
MySQL as the backend with MS Access front end. Access locks at the table level whereas MySQL only locks at field level.
MS Access makes front end design easy so just use it to create reports and queries.
Comment by Steven — 22-08-2008 @ 4:32
Of course, it depends on your requirements, but even with small applications or websites - I would never use Access, Excel or any of those as a database. It might be easy to set up in the beginning but will start to suck when you start to do more compley stuff. These kind of databases are binary, so you can’t access them with an Editor or write back-up scripts yourself etc…If you want a free and easy to use DB, download “MySQL5″ - it’s free. Other good commercial databases are “DB2″, “Oracle” or “MSSQL Server”.
BTW - “Access” uses “JetSQL” whose dialect REALLY sucks.
Comment by snake eyes — 23-08-2008 @ 10:01
I use Microsoft Access for developing small databases. It is easy to use but it is a bit expensive and I find it unstable. For larger applications, I would use mySQL because it’s opensource, stable, fast, well supported and is a great backend for dynamic websites.
Comment by blackraven_3 — 24-08-2008 @ 2:19
Define database? People refer to Excel / Calc which is spreadsheet software, not database software.
No one has mentioned SQL Server in all its versions and flavors.
No indication of scale or number of users.
Results undefined.
Comment by steve s — 25-08-2008 @ 22:15