I post this topic "Alternative database for MS Access" for the reason,that it would be better if I ask some ideas here in this site. But first this topic only focuses on a stand alone databases that is easy, reliable, and a hassle free databases. MySQL, MSSQL Server and any other databases that depending on a Server base are excluded only those database that can run stand alone and has the capabilities of the so called "Relational Database"are included.
What comes to my mind is I want to ask some ideas from you readers what would be the best database that suits for the needs of the developer and a user. Here I would like to site 2 samples of the database that I have known for stand alone and commonly use in developing application.
1. MS Access- a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications [ " Wikipedia " ]. I have no question for this one since this is the most commonly use of all the developer and to those newbie also.
2. SQLite- uses a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity. A multitasking database concerning reads. Writes can be done only one-at-a-time. It is a popular choice for local/client storage on web browsers. It has many bindings to programming languages. It is arguably the most widely used database engine, as it is used today by several widespread browsers, operating systems, embedded systems among others[ " Wikipedia " ]. For me, this is my second choice as my database when I'm trying to develop applications. It is very well said from its definition that it is concerning more on reading and writing, writing can be done only one-at-a-time.
General Information:
1. MS Access - Developed by Microsoft in the year 1992 with the latest stable version of 14 (2010) under the Proprietary Software License.
2. SQLite - Developed by D. Richard Hipp on July 17, 2000 with the latest stable version of 3.7.6.2 (2011-04-17) under the Public Domain Software License.
Operating Support:
1.) MS Access- Only for Windows.
2.) SQLite - Supports on the platform of Windows, Mac OS X, Linux, BSD, Unix, AmigaOS, and Symbian.
Limits and Capacity;
1. MS Access- Max DB Size - 2GB, and Max BLOB/CLOB size - 64K (Memo Field) and 1GB (OLE Object)
2. SQLite - Max DB Size - 32 TB (230 pages * 32 kB max page size), and Max BLOB/CLOB size - 1 GB
And thats all the important things that I share here maybe it would also be better if you give your own opinion and suggestions and comments on the what would be the best alternative database for developing application..
