A few of our Products
In this section we would like to publish one of our internal projects which we have used during previous
commercial projects.
SQL Inspector
The application can be a proper solution in case you need to get orientation in a new (or poorly documented) database. As a database tool it can be useful for IT analysts, consultants, database specialists, SQL developers, and programmers. Especially when they need to:
✅ create complex SQL SELECT commands in a visual way by simple mouse clicks, with a special JOIN conditions editor (with data type compatibility highlighting, and more),
✅ get an orientation in the new database (or poorly documented database) by VISUALIZING TABLE RELATIONS with their CONSTRAINTS, as well as the whole REFERENCING HIERARCHY of the selected table (what tables refer to the selected table, and where the selected table refers to),
✅ get a LIST of database objects where some table (or other database object) is used,
✅ get an advanced PROFILE of selected table (indexes, constraints, duplicities, and other info), or create an advanced data filter upon the selected table,
✅ search for a specified value with ADVANCED OPTIONS in all database tables.
Gallery of screenshots:
SQL Stopro
Database tool for visual building the T-SQL Stored Procedures on Microsoft SQL Server.
The application should help you if you want to:
✅ build up stored procedure's skeleton using visual way,
✅ effectively divide the T-SQL script of stored procedure into the logical parts,
✅ quickly navigate between stored procedure parts and use a wide code snippet gallery,
✅ easy upload and test your procedure with different parameters.
Gallery of screenshots:
VQB Visual Query Builder
The application provides a visual way for building either simple or complex T-SQL SELECT queries. It provides options and features for comfortable query design, especially by tables joining constructions.
Main features:
✅ Visual way of simple/complex SQL select query designing.
✅ Advanced where clause building where high level of inner conditions nesting is allowed.
✅ Multiple joining across multiple tables with column datatype checking (with precision), visual navigation, and self joining.
✅ Visualization of complete referencing hierarchy built by constraints.
✅ Create referencing path(s) if you need to join multiple tables using primary keys and foreign keys.
✅ Table constraints visualization (what refers to the selected table and where the selected table refers).
✅ User friendly interface.
Gallery of screenshots:
Advanced FlexiWidgets
The application is primarily designated to IT companies, sellers, analysts, managers, or developers, which would like to improve the UI/UX of their systems for their customers or end-users as an additional improvement. Suitable especially for corporate systems like Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), Supply Chain Management (SCM), and other systems supporting the business.
MAIN FEATURES OF THE PRODUCT:
✅ Universal solution that makes you able to make desktop widget from portable desktop application (almost any executable desktop application),
✅ The widgets can be shown always as the top windows or as the bottom windows like a part of your desktop background,
✅ The widgets can interact using mouse or keyboard if needed, otherwise they do not accept mouse or keyboard commands and whole interaction is passed to the windows located under the widgets.
✅ There is possibility to switch between different Widget modes using keyboard (2x Ctrl press) or mouse cursor position (Y=0 location)
✅ You can distribute your widgets to your end-users using .dwe file, which can be easily load into non-DISTRIBUTOR editions of the application.
✅ You can use your own 16x16 icon (i.e. as a logo of your company) in tray bar to open the widget controlling menu.
✅ There is no need to make any additional configurations or interventions to your current application,
✅ The widgets can be configurable separately or as a whole set of widgets,
MAIN ADVANTAGES IN COMPARISON TO MAJORITY WIDGET SOLUTIONS:
✅ Ability to make executable apps to become the widgets.
✅ Simple controlling with powerful possibilities of widgets.
✅ Make distributable package (.dwe file) encapsulating your widgets to be distributed (or additionally selled) to your end users.
HOW IT WORKS:
❶ Consider what kind of data can be interesting for your customers (depending on the kind of your current application), i.e. waiting or completed orders per day or last week, etc.
❷ Decide what kinds of the widgets can be useful for your end-users, i.e. Label, Line/Bar Chart, Table, etc. for displaying the data.
❸ Develop simple desktop applications with a few controls which fetch the data from SQL server database, REST endpoints, or web services considering user roles and access control privileges. These simple application must deals as the autonomous portable apps.
❹ Register your apps as the widgets in DISTRIBUTOR edition of the Advanced FlexiWidgets application.
❺ Distribute your .dwe widgets installation packages to your end users as a paid or free extension of your application.
(Every of the end-users should buy one of the END USER editions (per machine) beside your .dwe widget distribution file.)
BRIEF RUNNING WIDGET CONTROLLING:
Running Widgets can be controlled anytime using following commands:
⏵ 2x Ctrl press - switches between four modes (widgets on top/bottom, interaction using mouse and keyboard enabled/disabled)
⏵ 2x Context Menu key press - makes widgets visible/invisible (usefull when you want to temporarily hide widget content)
⏵ by keeping the mouse cursor on the top of screen for 1,5 sec. (where cursor's Y-cordinate equals to 0) to switch the widgets between:
• top-most position + 100% opacity + enabled interaction, or
• bottom-most position + 50% opacity + disabled interaction.
Gallery of screenshots:
