Sign in Join
Wiki copytemporary

Projects using Lazarus - Databases and Tools: what changed

Revision 2 to 3. Removed lines have a minus sign; added lines have a plus sign.

OldNewLine
11## Contacts Database
22
33[[Contacts Database]] is a small application that builds on the example address book application that comes packaged with Lazarus. This version has an altered database structure and allows the user to print either the current record or all of the database records. [Source available](http://www.wibblytim.co.uk/contactdatabase.php).
44
55## DB-Admin
66
77A small application for managing databases, including generating SQL statements and graphical SQL editor for Maria-DB, MySql, SQLIte and PostreSql. Files -\> not up to date \[<https://sourceforge.net/projects/db-admin/files/latest/download>\| Application (Linux only) \], compile it better from the sources
88
99 git clone ssh://dirkgraf@git.code.sf.net/p/db-admin/code db-admin-code
1010
1111or the site <https://sourceforge.net/p/db-admin>
1212
13-<img src="db_adm1.png" title="db_adm1.png" width="400" alt="db_adm1.png" /> <img src="db_adm2.png" title="db_adm2.png" width="400" alt="db_adm2.png" /> <img src="db_adm3.png" title="db_adm3.png" width="400" alt="db_adm3.png" />
13+![](/wiki-images/8/8f/Db_adm1.png) ![](/wiki-images/e/e5/Db_adm2.png) ![](/wiki-images/e/ea/Db_adm3.png)
1414
1515## Debio-Sql
1616
1717[Download](http://debio-sql.sourceforge.io) Debio-Sql is a database SQL management tool for the Firebird RDBMS.
1818
19-<img src="Debio-SqlCreate-Alter_Table.png" title="Debio-Sql Create Alter Table" height="300" />
19+![](/wiki-images/e/e4/Debio-SqlCreate-Alter_Table.png)
2020
2121## GTK-Fireadmin
2222
2323[GTK-Fireadmin](http://sourceforge.net/projects/gtkfireadmin/) is an Gtk based FireBird Administration tool and it is written OOPascal (Free Pascal) using Firebird Lazarus Components.
2424
2525## JPDB Admin for MariaDB
2626
2727[JPDB Admin for MariaDB](https://jpdb-admin-for-mariadb.jaleco.com/download) is a tool for managing and developing with MariaDB, MySQL and Percona Server. It allows one to visually create tables, views, triggers and other structures. JPDB Admin for MariaDB, has free and trial versions and is available in seven languages​​: Chinese, English, German, Japanese, Portuguese, Russian and Spanish. It is also runs on Windows, Linux GTK2 or QT, with DEB and RPM packages and tar.gz binaries, as well as 32bits or 64bits. Features include:
2828
2929- Multi-platform and multilingual​​
3030- Supports Unicode and character tables
3131- Assistant to create tables using a data grid view
3232- Create and edit the main database objects (views, triggers, functions and others)
3333- Several dialogs for creating, editing and/or deleting fields, keys, foreign keys and others
3434- Dialog for managing users and permissions
3535- Data visualization, including BLOB (image) and MEMO fields
3636- Full SQL query executor and SQL scripts editor with syntax highlighting and code completion intelligent
3737- Generates scripts CREATE, DROP, SELECT, INSERT and UPDATE statements to the script editor or clipboard
3838- Reports of the SQL Scripts and of the query results, previews, and export the report to PDF, HTML, text and image
3939- Export SQL scripts to HTML with syntax highlighting
4040- Visual Query Builder (Visually create queries without knowing SQL)
4141- Tools for monitoring servers MariaDB, MySQL and Percona Server
4242- Export table data to SQL, TXT, CSV, XML, JSON and others
4343- Database Export Assistant (extraction of the data and/or metadata)
4444- Import data from SQL files
4545
46-<img src="JPDB_Screenshort1.png" title="JPDB_Screenshort1.png" width="400" alt="JPDB_Screenshort1.png" /> <img src="JPDB_Screenshort2.png" title="JPDB_Screenshort2.png" width="400" alt="JPDB_Screenshort2.png" />
46+![](/wiki-images/b/b0/JPDB_Screenshort1.png) ![](/wiki-images/7/73/JPDB_Screenshort2.png)
4747
4848## Laz Open QBuilder
4949
5050[Laz Open QBuilder](https://github.com/tcs-ulli/lazopenqbuilder) is a derivative of Fastreport's open source Open QBuilder for Delphi. It is a Visual Query Builder, also known as QBE, like the one used in #JPDB Admin for MariaDB, Microsoft Access and other database tools. Based on Jepafi's work in porting to Lazarus and adding Zeos support, this version adds SQLDB and IBX (in development) support.
5151
52-<img src="lazopenqbuilder.png" title="lazopenqbuilder.png" width="400" />
52+![](/wiki-images/b/b8/Lazopenqbuilder.png)
5353
5454## LazSqlX
5555
5656[LazSqlX](https://sourceforge.net/projects/lazsqlx/) is a Multiplatform mini sql Manager built completely with Lazarus FPC. It comes in handy to any developer who works with MsSQL, Oracle, MySql,Sqlite,Firebird and PostgreSql. It provides them with an intuitive database management tool that can be used to browse the database structure, generate and execute queries and stored procedures, view table information and create new tables.
5757
58-<img src="NewLazSqlX_Screenshot2.png" title="NewLazSqlX_Screenshot2.png" width="400" />
58+![](/wiki-images/8/84/NewLazSqlX_Screenshot2.png)
5959
6060## LDBase
6161
6262[LDBase](https://sourceforge.net/projects/ldbase/) is a tool for database developers. It allows developers to create, modify and erase tables; it also allows developers to create, modify and erase indexes, export data and many more things. It is a powerful tool for database developers. It works only for Windows.
6363
6464## MyDBFStudio
6565
6666[MyDBFStudio](https://github.com/wp-xyz/MyDBFStudio) is a multi-platform open source program made with Lazarus that will help you to manage your dbf tables (dBase). The main features are:
6767
6868- Work with multiple tables at once, in a tabbed user interface.
6969- Add, modify or delete data.
7070- View deleted data.
7171- Create, empty, delete, change or restructure a table.
7272- Create, delete or modify any index in a table.
7373- Add or substract two tables.
7474- Directly export data in the following formats: CSV, HTML, XLS, DBF, XML or SQL script.
7575- It works on Windows, Linux and all platforms supported by Lazarus.
7676
7777The original author is Enzo Antonio Calogiuri (aka Fog76).
7878
79-<img src="MyDBFStudio_v0.6.0.png" title="MyDBFStudio_v0.6.0.png" width="400" />
79+![](/wiki-images/c/c2/MyDBFStudio_v0.6.0.png)
8080
8181## Modelador Proyectos
8282
8383[Modelador](http://lulasoftware.com.mx/es/proyectos/modelador-de-proyectos) is a tool for create relational database models. It's focused in PostgreSQL, managing types, domains, stored procedures and tables (in a graphical way). It's compiled for Windows, in spanish. Download in [SourceForge](https://sourceforge.net/projects/modeladorpostgres/), see documentation (at this time only in spanish) at [Lulasoftware](http://lulasoftware.com.mx/es/proyectos/modelador-de-proyectos).
8484
85-<img src="modelador01.jpg" title="modelador01.jpg" width="400" alt="modelador01.jpg" /> <img src="modelador02.jpg" title="modelador02.jpg" width="400" alt="modelador02.jpg" />
85+![](/wiki-images/e/e6/Modelador01.jpg) ![](/wiki-images/1/1b/Modelador02.jpg)
8686
8787## NSBase
8888
8989NSBase is a database management system. NSBase use SQLite, Firefird, Interbase, MariaDB, Mysql, Postgresql, Sybase It allows to quickly build complete database applications. Its modern interface is simple and ergonomic. Its scripting in LUA makes it possible to dynamize your applications. It is a rapid development workshop (IDE / RAD) visual type (sqlite form generator). It is a real alternative to MSAccess, kexi and other. Import your database : Text files, MS Access (MDB File), SQLite and Kexi Build your applications quickly, thanks to integrated wizards It can create stand-alone applications without specific installation, it generates an exe file under windows quickly and easily (or the equivalent under linux)
9090
9191<https://sourceforge.net/projects/nsbase/>
9292
93-<img src="nsbase.png" title="nsbase.png" width="400" />
93+![](/wiki-images/4/48/Nsbase.png)
9494
9595## ParadoxViewer
9696
9797[ParadoxViewer](https://github.com/wp-xyz/ParadoxViewer) is a viewer for ancient PARADOX database files. Using the directory tree navigate to the folder with the PARADOX file to be viewed, and select the file in the file list. The records will be displayed in the tab "Data" in a DBGrid, and the field structure is listed in the tab Fields. The table can be exported as an SQLite3 file for usage in modern programs.
9898
9999ParadoxViewer works on Windows both as a 32-bit or 64-bit application. Other operating systems were not tested, but should work, too. An external DLL is not required.
100100
101101NOTE: This program does not allow editing the PARADOX data files.
102102
103-<img src="paradoxviewer.png" title="paradoxviewer.png" width="400" />
103+![](/wiki-images/3/31/Paradoxviewer.png)
104104
105105## Spready
106106
107107[Spready](https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/applications/spready/) is a grid demo using [[FPSpreadsheet]] aimed at demonstrating its capabilities. It can read/write .xls, .xlsx, and .ods spreadsheet files and can write to Wikitable format - handy if you want to paste tables into this wiki ;)
108108
109-<img src="fpsgrid.png" title="fpsgrid.png" width="400" />
109+![](/wiki-images/b/b7/Fpsgrid.png)
110110
111111## Turbo Bird
112112
113113[Turbo Bird](http://code.sd/turbobird/) is a FireBird administration tool that enables developers and administrators to create tables, procedures, Triggers, build relations, and all other Firebird properties.
114114
115-<img src="main.png" title="main.png" width="400" />
115+![](/wiki-images/c/cb/Main.png)
116116
117117---
118118*From the Free Pascal wiki, page "Projects using Lazarus - Databases and Tools", as it stood on 2024-05-08 after a change by Jlneuts, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's [[Licensing]] page. If you have concerns about this material, [message the admin](/wiki-contact).*
119119Category: Databases
120120Category: Lazarus
121121Category: Promotion
122122Category: Software created with Lazarus
123123Category: Software written in Free Pascal

Back to history