hi,
I have to create a program that can schedule tasks and hearing dates.
Last programmed with databases over a decade ago. Back in the day used Visual Basic, C and also pascal amongst a few others so very rusty.
Which database would you suggest that fits the bill below?
1. Start off single user on local machine.
2. Once app grows, then switch to working over internet (including merging single user databases into one big central one).
3. Encrypted preferred unless this will affect speed a lot.
4. Have 2-3 database files open. eg. user, common. Would like to be able to query and build relations between both files and tables within.
5. Speed over internet.
6. Small size for distribution.
7. Free
Was going to use sqlite, but need to future proof (2) so can't use sqlite as it doesn't have proper multi-user capabilities. (Only 1 user can write at a time).
To fulfil 1,2,6 the only conclusion I came up with was Firebird.
However, 5 seems to be problem with slow speed over internet stated here (
http://www.firebirdfaq.org/faq53/).
Also, tried creating relationships in tables and had problem creating many to many gui relationship. Not sure what the problem is here?
Storing procedures in the database seems to be a pain from my reading?
Not sure if my concerns about firebird can be resolved by some guidance from here?
Or if another solution available that is small, free, can do both embedded single user and central multi-user without much change.
Thanks