Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

Adam Allen: "I just have to say WOW!!! I'm so glad that you guys have developed something that is so useful for MySql. I am able to graphically view my tables, and I don't even have to think about my queries because I can visually design them. I just stumbled upon this, and I'm already very excited about it".

More

Add your opinion

SQL Maestro Group / News / SQLite Maestro 11.3 released

SQLite Maestro 11.3 released

Mar 9, 2011

Prev Next
SQLite Maestro

SQL Maestro Group is happy to announce the release of SQLite Maestro 11.3, a powerful Windows GUI solution for SQLite server administration and database development.

Please consider the list of new features implemented in this version since the last official release:

Server management extensions:

  • SQLite Maestro has been successfully tested with the latest SQLite server versions. The latest available server library (3.7.5) is now included into the installation package.
  • Support for SQLite full-text search extension modules has been implemented (both FTS3 and FTS4 are supported). These extensions allow users to create special tables with a built-in full-text index (also known as FTS tables). The full-text index allows the user to efficiently query the database for all rows that contain one or more words, even if the table contains many large documents.

    Support for full text searchPicture 1. FTS support

    To display the FTS "shadow" tables (%_content, %_segdir, etc), turn on the Show system tables option in the Edit Database Profile dialog.
  • Now it's allowed to generate updatable views for your tables automatically. Moreover, the Insert, Update, and Delete operations can be enabled or disabled at your choice. It is possible to create a view for a single table or for several tables at once (even for all the tables in the database). To accomplish these tasks, use the popup menu of the corresponding node at the Explorer tree and the Main Menu | Object | Generate updatable views accordingly.

    Updatable views generationPicture 2. Updatable views generation

Interface improvements:

  • Table Editor features an ability to upload files as BLOBs into a table. The file names must contain the information on the record they need to be placed to: the files need to be named in the same manner and their names have to include content of one or several table columns that can uniquely identify each row.
  • Data Import: starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
    • To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).

      Connecting to ODBC data sourcePicture 3. Data Import: connecting to an ODBC data source

    • Another thing to note is that this kind of import completely supports BLOBs (if they are supported by the ODBC driver / OLE DB provider used).
  • Application Options: now it's possible to specify default directories for data export/import/extract/etc to be used on database profiles creating.

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.


Related links:

SQLite Maestro home page
Download SQLite Maestro
Get SQLite Maestro Tour
Purchase your license of SQLite Maestro today!
Prev Next