Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added example
Source Link
MyICQ
  • 111
  • 4

I am looking for a generic input frontend to perform simple CRUD in a database, either MySQL or SQLite. Ideally I should be able to read the table specification (describe XYZ) and the program would automatically create input boxes for this table, possibly with restrictions for length and different types.

It it assumed that the tables are fairly simple and no releation checks need to be done.

I am not looking for a PHP / Java / or other web solution. Should be a windows software.

If it exists, I can spare myself creating it.

Edit: needed software could read creation and make a GUI with input fields:

Field       Type         
----------  -----------  
test        varchar(80)  <<< normal text input, limit 80
field2      varchar(80)  <<< normal text input, limit 80
somedate    datetime     <<< date selector
yesnofield  tinyint(1)   <<< checkbox

I am looking for a generic input frontend to perform simple CRUD in a database, either MySQL or SQLite. Ideally I should be able to read the table specification (describe XYZ) and the program would automatically create input boxes for this table, possibly with restrictions for length and different types.

It it assumed that the tables are fairly simple and no releation checks need to be done.

I am not looking for a PHP / Java / or other web solution. Should be a windows software.

If it exists, I can spare myself creating it.

I am looking for a generic input frontend to perform simple CRUD in a database, either MySQL or SQLite. Ideally I should be able to read the table specification (describe XYZ) and the program would automatically create input boxes for this table, possibly with restrictions for length and different types.

It it assumed that the tables are fairly simple and no releation checks need to be done.

I am not looking for a PHP / Java / or other web solution. Should be a windows software.

If it exists, I can spare myself creating it.

Edit: needed software could read creation and make a GUI with input fields:

Field       Type         
----------  -----------  
test        varchar(80)  <<< normal text input, limit 80
field2      varchar(80)  <<< normal text input, limit 80
somedate    datetime     <<< date selector
yesnofield  tinyint(1)   <<< checkbox
Source Link
MyICQ
  • 111
  • 4

Is there a GENERIC (windows) program to do CRUD for a database table

I am looking for a generic input frontend to perform simple CRUD in a database, either MySQL or SQLite. Ideally I should be able to read the table specification (describe XYZ) and the program would automatically create input boxes for this table, possibly with restrictions for length and different types.

It it assumed that the tables are fairly simple and no releation checks need to be done.

I am not looking for a PHP / Java / or other web solution. Should be a windows software.

If it exists, I can spare myself creating it.