So I'm looking for a database server which needs to run with the following requirements:

  1. Run on Windows XP.
  2. Log in via TCP/IP.
  3. Authentication.
  4. Expose custom stored procedures.

It will be running on an embedded CPU and will primarily facilitate data-logging.

The data itself will be quite simple. Only a few tables at most, but may potentially reach ~200GB in size. There will only be one write pipeline, and multiple (but few) readers.

Some of the options I've considered:

  • MySQL - slightly worried about the cost/licensing, as we're an OEM.
  • SQLite - file-based (so no native tcp/ip access), no stored procedures.
  • PostgeSQL - might be too big/complex.

Any insights/suggestions welcome!

  • 2
    if MySQL is not too large/complex -- MariaDB? -- the free fork of MySQL, GNU GPL lic – flamey Sep 20 '18 at 17:04
  • 1
    Logging in over a network and an embedded system mean two totally different things. Please explain. – Basil Bourque Sep 23 '18 at 0:57
  • @BasilBourque Effectively this is for the computer embedded in an OEM unit. Labelling a system as embedded doesn't preclude it from having the capability of network access. – John Go-Soco Sep 24 '18 at 7:39
  • 1
    We've each been using a different meaning of embedded. Apparently you meant embedded system while I meant a database engine built-in as a part of the app rather than running separately in its own process (or machine) as a server. I suggest editing your Question to clarify. You may get better answers if you describe the characteristics and constraints of your embedded system hardware and OS. For example, Postgres most certainly is not built to be embedded, while the H2 Database Engine is (optionally) – Basil Bourque Sep 24 '18 at 7:44
  • Thanks for the clarification, @BasilBourque. I'll investigate a bit more into the definitions and modfiy the question accordingly. – John Go-Soco Sep 24 '18 at 7:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.