Connection framework for SQL databases (Lazarus/FPC)
- udmsqldb.pas/.lfm -- data module to connect to databases
- uguessfile.pas Unit -- for search and help function of various files.
- fcredentials.pas/lfm -- Manager for credentials and settings
Example application:
- frame_example1 -- sample frame with database and data functions.
- unit1.pas/lfm -- Main form of the sample application.
- + projectfiles
- Base for database sample programs
- Test environment for single forms or frames
- Base for database applications
- Beginner environment that takes care of everything except the assignment of the DB connection.
- usable also in productive environment
For example developers, the idea is that you can develop with any DB, include an SQL file with definitions and data, and the user can also view this example against any supported DB.
SQLite is the default database as ist is available on all platforms easily.
- database connectivity with all SQL databases supported by Lazarus.
- automatic import of sample data
- switching between database connections
- 32/64 bitness for access libraries possible
- Settings manager for databases and program settings
- Settings in INI file
- Default settings predefined
- Database selection and connection test possible before connect.
- clean file structure possible
- automatic use of standard libraries. Custom libraries possible
- Windows/Linux compatible (at least it should be)
- compatible sample database (currently tested with SQLite, MySQL/MariaDB) with structure diagram (in SQL folder) - bugreports welcome
and other helpers,,,
Saving the SQL credentials (passwords and server etc.) is not critical because for a sample program the INI file is not supplied. Missing config files are automatically generated locally with standard values when the application starts.
- copy the downloaded code to any folder
- open the project file (using Lazarus) located in the folder project_SQLdbGUI
- compile and run
- follow instructions in some message windows as they open.