[Openbts-discuss] sqlite vs mysql

[elektron <ele...@gm...>]

How would the OpenBTS devs/community feel about a patch that replaces
sqlite with MySQL?

I've setup OpenBTS on several machines, and the part the takes the
longest to configure is the numerous database files, and the pointers
to them. sqlite is more for single embedded applications. With all the
applications that exist now, it makes a lot more sense to go to
something that is more suited for the application. Plus, I think MySQL
could be an enabler for new capabilities, such as logging and a web
ui.

I would like to propose the following modifications:

1. Create command line arguments to specify MySQL database parameters
(with compiled in defaults).
2. Modify all OpenBTS applications (OpenBTS, transceiver, smqueue,
subscriberRegistry, etc)  to get configuration information from the
database.
3. Modify OpenBTS applications to store other items in the tables (ie,
subscriber registry, TMSI table, etc).
4. Modify log statements to optionally log to the database.
5. Create a database architecture that allows for revision maintenance
of tables. (ie, the code tracks schema versions, and modifies as
necessary).

Obviously, I propose to make these changes myself (as I stand to
benefit from them for my application). But before I go and make these
change, I would like to get the blessing of the devs on the direction.