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

Subscribe to our news:
Partners
Testimonials
Jacob Lyohne, Director of Development: "Regarding implementation, it is pretty self-explanatory and the SQLite Maestro manual is helpful for review and reference. We also found the on-line documentation useful and the software support staff readily available to answer our questions. Reports are very easy and quick to run and can be broken down into any number of statistical combinations".
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".

More

Add your opinion

Customers
SQL Maestro Group / Products / SQLite / News / PHP Generator 15.12 released

PHP Generator 15.12 released

Dec 10, 2015

Prev Next
PHP Generator

SQL Maestro Group is happy to announce the release of PHP Generator 15.12, a GUI frontend that allows you to build high-quality and feature-rich data-driven web applications for your database in minutes. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.

The following is a list of new feature implementations since the last major release. For those who prefer video to text, we created a video tour that covers some new features and uploaded it to our YouTube channel.

New feature highlights:

  • New modern look and feel. The primary goal of this new release is to provide expanded capabilities for constructing modern-looking and powerful web applications in the simplest way possible. For this purpose we significantly changed the design for all generated pages and refactored the web code. We know you and your end-users will enjoy the new UI. As usual, all the new features can be seen in action in our demo application.
  • 100% responsive design. This new version allows you to generate responsive pages that look beautiful on any device from a mobile phone up to an extra-large desktop.
    Picture 1. Responsive design
    • View, edit, and insert forms are responsive out of the box in both separate and modal modes (no special settings are required)
    • For list pages there are two ways to make them responsive:
      • Define column visibility for each display resolution (mobile, tablet, desktop, large desktop).
        Setting column visibilityPicture 2. Setting column visibility
      • Define the maximum number of cards to be displayed horizontally in card mode.
      Easily switch from grid mode to card mode and vice versa using the Page Settings dialog (if allowed by the app creator).
      Page Settings DialogPicture 3. Page Settings Dialog
  • Top side drop-down menus. The new UI provides a space-saving way to navigate between pages. This is extremely useful for apps with a lot of pages while the old-style sidebar navigation is supported too. It is also possible to disable all menus.
    Top side drop-down menusPicture 4. Top side drop-down menus
  • Enhanced Filter Builder. This significantly updated tool now provides a much more intuitive UI to help your end-users build complex filter criteria with an unlimited number of filter conditions combined by logical operators.
    Filter Builder DialogPicture 5. Filter Builder Dialog
    The control now supports "Between", "Not between", "Is blank", and "Is not blank" predicates and allows you to temporarily disable the filter in a single click.
    Disabling applied filterPicture 6. Disabling applied filter
  • Multi-column sorting. There are two ways to order the data by multiple columns:
    • To add a column to the current sort order, click its header holding the SHIFT key (only for grid views). To remove a column from the current sort order, click its header holding the CTRL key.
    • It is also possible to sort data by one or multiple columns using the Sort dialog that can be invoked by pressing the appropriate button on the toolbar. This way works for both grid and card views.
      The Sort dialogPicture 7. The Sort dialog
  • Keyboard shortcuts. This feature can make it easier to interact with generated applications saving you time and effort on performing typical operations such as adding a new record or submitting a form. The complete list of available hotkeys can be found here.
  • New and updated controls. This version extends the already wide spectrum of components available in grids, cards, and edit/insert forms.
    • Brand new Autocomplete and Multi-level autocomplete editors that provide an unprecedented flexibility for formatting search results and the selection.
      Autocomplete editorPicture 8. Autocomplete editor
    • New Date, Time, and DateTime controls. These stylish looking and clean editors help you to select desired date/time/datetime values in the simplest way possible.
      DateTime controlPicture 9. DateTime control
    • New Multiselect editor. This control provides the same functionality as Checkbox Group (i.e. allows you to select several options for a single field) is easy to use, and requires less space in the forms.
      Multiselect controlPicture 10. Multiselect control
    • Updated HTML WYSIWYG control. Allow your end-users to easily create and edit rich text values without knowledge of HTML syntax.
      HTML WYSIWYG controlPicture 11. HTML WYSIWYG control
    • An external audio file view component is now available. This allows you to use the standard HTML5 audio player in your applications.
      External audio filePicture 12. External audio file
  • Event management enhancements. Make your application even more flexible and customized with the updated event model.
  • Less pre-processor syntax for user-defined styles. This feature allows you to make your style-related code more compact and clean, as well as design page elements according to the color scheme.

    Example of conditional formatting based of cell's value.

  • 18 color themes. Light and dark, soft and contrasting, spacious and compact — everyone can choose a theme according to their taste. It is also possible to customize any of the available themes, or even create a new one.
    Cerulean color schemePicture 15. Available color themes

    Runtime theme selection can be added with just a few lines of code (see example here).

  • Font-based icons. Starting from this version all icons used in the software are in vector format. These icons look great in any color theme and can be customized with the full power of CSS.
    Font based icons (Cerulean color theme)Picture 16. Font based icons (Cerulean color theme)
    Font based icons (Sandstone color theme)Picture 17. Font based icons (Sandstone color theme)
  • HTML filter is now available for Text, Text area, and WYSIWYG editors. Use it to strip unwanted HTML tags and attributes from user input.
    HTML filterPicture 18. HTML filter

In addition to above, several bugs have been fixed and some other minor improvements and corrections have been made. For more information about a specific tool see the appropriate page:

Prev Next
Back to news archive