What DBMS can store the database in one file?

A

Alexander2021-02-12 03:30:41

Database

Alexander, 2021-02-12 03:30:41

There is Altium Designer and a database of radio components in Access (.mdb file). You need to get rid of Access.

You need a lightweight DBMS with data storage in the form of a single file and with the ability to connect Altium (ODBC or some similar driver) to it.

I tried LibreOffice Base, it doesn't know how to give access (or I'm dumb and don't know how to do it).
What other options are there?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

Y

Yerlan Ibraev, 2021-02-12
@mad_nazgul

It used to be the popular Firebird .
Just the DB was stored in one file.
Well, the RDBMS itself is not bad.

V

VitalyChaikin, 2021-02-12
@VitalyChaikin

SQL LITE - considered lightweight with support for sql queries;
(mdb is a normal format, only it needs to be used without the Access shell, DAO / ADO - in file-database-mode *; under Access, all sorts of front-end nonsense is added there)