Benscomputer.no-ip.org

About Claims_DB

Claims_DB is a BASH based database engine. It currently supports record insertion, record retrieval and basic querying. All database tables are stored in CSV format for easy data access in a variety of applications.

History

I began writing Claims_DB in order to see if I could. I also had a requirement for a database, and was struggling to find anything that would suit my needs. Databases such as MySQL and PostgreSQL were far too big for the particular project, whilst other smaller solutions tended to be platform specific.

Writing the system in BASH doesn't exactly satisfy the portability requirements, but did allow me to easily create a web based interface.

Licensing

All code within the project is licensed under the GNU GPL, for a copy of the current license see here. All written documentation is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike2.5 License.

If these licenses do not meet your needs, then please Contact Me so that we can negotiate an arrangement.

TODO List

View the latest TODO list in BUGGER.

Automatic Primary Key Generation
Remove reliance on temporary files
Database/Table Add/Remove funtionality
Faster query execution

Scalability

Obviously a big issue for any Database solution is how well it scales, initial use suggests that the system does scale reasonably well. I currently have close to millions of lines of data in one of the implementations, the biggest issue at this level is query response.

One major drawback of the current release is that it doesn't support simultaneous queries very well. It currently has something of a reliance on temporary files, so simultaneous connections can create a clash.
This is a top priority for the next releases, either by replacing temporary files with locations in memory, or by making the temporary filenames unique.