Click here to Skip to main content
14,607,949 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have a small relational database implemented on MS Access having 7-8 small tables (number of records in the largest table <1000). Nowadays I need to build new project based on this old DB implementation, and I want to find correct decision what is best DB to use.

The most disadvantage of MS Access is its poor VBA language and modules stored together with the DB data in one file with no possibility to be extracted and managed.

From other hand I am finding the decision to keep all data in one file (like it is done in MS Access – all DB data are contained in one .accdb file) very handy.

Thus, this is the list of requirements to such new DB:

1. To store tables in one file-container that can be passed to any
person having Windows or Linux. This person should be able
to browse this file using only easily accessible preinstalled
software.
2. The IDE for this DB should have all basic UI friendly features that
can be found in MS Access, namely:
- Manage DB tables: creation, deletion, modification
- Table relationship visual tool
- Table browser/editor with ability to check relationship restrictions
- Building and storing SQL queries
- Optional: GUI forms designer
3. Programming languages:
- Python
- Optional: C++
- Optional: Perl

What is the best Database I am looking for?

What I have tried:

MS-Access project + its VBA language
Posted
Updated 18-May-20 20:28pm
Comments
Maciej Los 18-May-20 17:29pm
   
What about tinydb[^] (written in clear Python)?

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Maybe SQLite, see: SQLite Python[^]
To manage your database you could use a tool like DBeaver: database-clients~dbeaver[^]

You might also be interested in microsoft-access-alternatives[^]
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100