dbWinSQL and dbWinSQLpro are programs that allow an easy approach to the development platform "Gea". At lower level, once connected to a database (currently only PostrgreSQL), it read the database structure completely autonomously and offer a Front-End with different options according to the program:
- Maintenance of simple tables (master).
- Generation and reporting.
- Transactions, including various types of Export, Import and updates.
- Backup (dqWinSQLpro only).
In this first level, the programs provide a direct and simple way to keep database without intervention of developers and technicians. They are utilities whose profitability is guaranteed to cover needs of many small business.
At the next level, both programs can be converted as, with the help of a developer, or a computer user with basic knowledge of data-oriented programming.
At this point you can get maintenance screens designed as master tables, or (in dbWinpro only) complex maintenance screen of movement tables as orders, RMA, invoices, etc. In your report, you can also go well beyond the lists generated automatically and can develop all kinds of documents with few limitations. The same applies to transactions can design specific processes.
The best approach at this level is the AppDesigner program (currently beta), the documentation explains step by step how to create menus, maintenance screens and reports, and how to fully exploit the transactions.
