Wednesday, January 11, 2023

MySQL Code Generator & more

MySQL Generator:  https://www.fpmgonline.com/mysql_generator.php
"... a Free, web based, powerful tool to increase web development productivity and to cut down time that you spend on writing MySQL Queries/Statements of all nature, regardless of the platform you choose."

SQLMaestro - PHP Generator for MySQL:  https://www.sqlmaestro.com/products/mysql/phpgenerator
"PHP Generator for MySQL allows you to create applications that look fine on any device from a mobile phone to an extralarge desktop.
  ... easy-to-use data input forms with wide spectrum of controls.
  ... allows you to filter, sort, compare, and partition data according to your needs.
  ... charts, exporting, & printing"
Thye have several other products for MySql at the same site.

Create table - Online SQL Generator:  https://wtools.io/generate-sql-create-table
"Form for generating SQL query for MySQL"

Smart Form Maker:  https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/
"... easy to use tool for building  AJAX forms from scratch to manage the records of your MYSQL database with a few mouse clicks -
    Easy to use wizard-style interface.
    Generate and manage an unlimited number of dynamic forms from your MySQL database
    Extensive form types:
        Columnar forms (standard forms).
        Editable grid (help you process multiple records at once).
        justified forms.
        Mobile forms.
        Master details form(sub-forms)."

-------------------------------------------------------------------------------------------------------------------------------------------------------------
Filemaker to Mysql
http://stackoverflow.com/questions/7056022/ddg#7056211

The simplest way is to export data from FileMaker into some common format. To do this you need to open the file in FileMaker and for each table you need go to the layout associated with the table and use the menu to show all records and export.

Make sure to only export data fields (Text, Number, Date, Time, and Timestamp), because it's typical for FileMaker to have lots of calculated fields (Calculation and Summary). (To do this first go to File - Define Database, then to some table, sort files by type, and note the last data field.

This won't export container fields, but most apps don't store such data. It's still possible to export them too but it would require a custom script.

The next option is to use ODBC. It's 'next' because it's less convenient and usually slower.

If you don't have a copy of FileMaker, you can download a 45-day trial from their site; it's fully functional.

No comments: