dbFront 1.4.2, Bug Bounty, Performance and ProcedureAPI

Wed, Oct 28, 2026

Last year we started a Bug Bounty for dbFront. The Bug Bounty received a number of responses with most reports pointing at server configuration issues, and two reports pointing at the need to secure the application Javascript in the browser.

In response, we updated dbFront to enforce server file integrity checks and automatically block any unrecognized or injected JavaScript.

Because dbFront version 1.4.1 and earlier lacked these JavaScript restrictions, they are susceptible to the Cross-Site Scripting (XSS) attack uncovered during the bounty program.  The patch released for dbFront 1.4.1 targets only the specific exploit demonstrated in the Bug Bounty. To permanently close the underlying attack vector, users should upgrade to dbFront 1.4.2.

Every dbFront installation is unique, and needs to be secured separately. In response to the configuration issues uncovered by the bug bounty program, we integrated a simple scanner directly into dbFront. This allows each administrator to proactively detect and resolve potential configuration & security issues in their own environment. For more details see: Security Scan

The security changes took longer to settle out because we were forced to rebuild our testing environment to work within the new security restrictions.

dbFront 1.4.2 - Security, Performance, Procedure API

dbFront 1.4.2 is now in the stable position on the download page. The security changes triggered by the bug bounty are the most significant new features. Beyond that, dbFront 1.4.2 also includes cleaner and faster selection and filtering queries. The ProcedureAPI was also extended and stabilized.

Along with the list of features, dbFront 1.4.2 also contains 48 bug fixes to various areas including security, record locking and more.

Below is the detailed feature list. A number of the features were requested via the Q&A.

  • Attachments: Allow "Camera Only" uploads
  • Expressions:
    • Added the [Can See Table] security expression (formerly Row Security) Q&A
    • Added IsGroupMemberNetwork() and IsGroupMemberSSO() for use in security expressions. Q&A
  • Form: Optionally preload the top record.
  • Layout: Added table CSS higher to allow more layout control.
  • ProcedureAPI:
    • Add the Debug Info to dialogs even if no form or buttons.
    • Allow direct BLOB/VarBinary (e.g. PDF) results. (Display/Download)
    • Limit recursion to level explicitly permitted by 'MaxRecursion', Default = 0.
    • OpenObject(%objectdata%, %filename%), See: ProcedureAPI
    • OpenTable() allow record and field selection (e.g. Attachment).
    • SendEmail() allow imbedded tables {%Table_1%}, {%Table_2%}
  • QuickSearch:
    • Improved search performance and index use on all join types.
    • Optionally limit the columns searched. Q&A
  • SSO
    • Allow testing Database(procedure) security on LocalHost while SSO is enabled.
    • Added optional Login Redirect Url. Often required by a LoadBalancer or Proxy.
    • Make the use of the Microsoft Graph API optional with Azure.
  • Security:
    • Add/Enforce Integrity Checks on all scripts.
    • Enforce use of secure cookies on secure connections.
    • Lock down embedded scripts to prevent injection attacks.
  • SystemMonitor:
    • Added Active Sessions list to the System Monitor
    • Added Security Scan to the System Monitor to help secure local installs.
  • WebRequest: On error, parse response JSON to show error detail provided by some APIs.

The full release history for the 1.4.2 branch can be found at dbFront.com/releasehistory

More to come...

  • A near future post will cover the new 1.4.5 version of dbFront which includes performance updates for large Excel/CSV imports and new SSO support for Windows Identities and Server Headers.
     
  • Work has also begun on PostgreSQL support!  Because this involves much more than simply adding a new database driver, it is currently targeted for dbFront version 1.5.0.
     
  • AI integration is under consideration for dbFront!  This could become an early-access investment opportunity, with special savings and priority access for participating investors.
     
  • and one more ...  I know a user who is currently developing a web store for dbFront-based database applications. It might be a good idea to polish up any projects you think would be a good fit.

Summary

We have been doing a lot of work to secure and enhance dbFront and to update the supporting documentation. If you have time, please consider creating or updating a review of dbFront.

Please see Submit Review for more details. The less effort we spend on sales and advertising, the more effort we can spend on improving and stabilizing dbFront.

Thanks - The Team at dbFront

Image from Melani Marfeld - Pixabay

Continue Reading...


dbFront 1.4.1, Stable with 39 features including a ProcedureAPI!

Fri, Feb 27, 2026

Lots has happened since the last blog post, which introduced dbFront 1.4.0.  The marketing gurus will tell you that I should have kept everyone informed, but I got busy.  Therefore, some of this post will be old news to the more adventurous, but not all.

dbFront 1.4.1 - Introducing the ProcedureAPI

dbFront 1.4.1 is the current stable release with 39 new features since 1.4.0. The most important feature introduced in this release of dbFront is the ProcedureAPI.  The ProcedureAPI allows stored procedures to do far more than return data or simple messages.  Using the ProcedureAPI, stored procedures can now enter into a full two-way conversation with dbFront, asking it to do things such as: prompt the user for additional information, retrieve information from another WebService, or generate reports.

When the Stored Procedure output style is set to "Server Directed" or "Automatic", dbFront examines the first result looking for a column named Action.  The value of that column determines how dbFront processes the stored procedure's remaining output.

dbFront currently supports the following action types:

  • Close: Exit with an optional message and optionally refresh the screen.
  • OpenDialog: Create a dialogue with optional: HTML Content, Form Fields, Custom Buttons and Table Results.  The updated Form Fields and Custom Button press are passed back to the procedure for further processing.
  • OpenReport: Open the procedure output as a Report or Export.
  • OpenTable: Redirect the user to a specific table.
  • OpenUrl: Redirect the user to a URL.
  • SendEmail: Have dbFront send an email and return to the procedure for further processing.
  • WebRequest: Have dbFront send a WebRequest and return the results to the procedure for further processing.

ProcedureAPI Examples

  • Simple Report Parameters
    Allows a stored procedure to display a dialogue with instructions and a prompt for missing parameters before proceeding.
     
  • Simple Report Parameters + Output Selection
    Extends the Report Parameters example and allows the user to choose to either Export to Excel or run a Quick Report.
     
  • Advanced Find or Create
    Creates an advanced and interactive lookup using a single stored procedure.  This same procedure is called repeatedly by dbFront with input from the self-created custom dialogue and responses from the web requests until the user is satisfied or the task is complete.

For more details, see: Procedure API

IMPORTANT: If you plan to investigate the Procedure API, then we suggest upgrading to dbFront 1.4.2 to take advantage of the latest updates and fixes.

dbFront 1.4.1 - Full Feature List

Below is the detailed feature list. A number of the features were requested via the Q&A. Buried in this feature list are some very powerful features, some of which we are going to expand upon in future blog posts.

  • Buttons:
    • Added a DebugShow to expose debug information at runtime. See: Buttons Main
    • Enhanced button visibility logic to only disable if fields are required or need to receive updates.
  • Core: Added timeouts to regex expression handling to prevent ReDoS attacks.
  • CrystalReportHelper: List stored credentials, without the passwords. See: CrystalReportHelper
  • MyLayout:
    • Ability to discard/reset MyLayout.
    • Removed admin details from MyLayout to make it match what regular users see.
  • ProcedureAPI:
    • Added "Close" action, and "Refresh" attribute to terminal actions. See: procedureapi#Close
    • Added "SendEmail" action to enable email notifications. See: procedureapi#SendEmail
    • Added OpenReport to allow SPs to exit with a report type. See:OpenReport
    • Added support for Password fields.
    • All messages/HTML are sanitized to block XSS or similar attacks.
    • Embed Debug info in dialogues if DebugShow enabled. See:Debugging ProcedureAPI
    • Further ensure that password field contents are hidden in logs or debug info.
    • Return the current UserId and Debug flag in request header.
    • Updated OpenDialog to support Select fields. See:OpenDialog
    • Allow {​%Form​Fields%}, {​%LogoUri%}, and {​%InspirationalQuote%} in form bodies.
    • Procedure-driven forms with input submitted directly to the procedure for processing.
    • Set the ClassList on the dialogue root. Allows full-screen dialogues and other enhanced effects.
  • Readme: Updated Readme.html with improved structure and updated help.
  • RequestHandler:
    • Allow Anonymous/Public Requests, See: Requests
    • Anonymous Dialogs (e.g. Forgot Password, Register New User, ...)
    • Simplified Parameters to the dbfHeader and dbfData
  • SAML: Refreshed SAML library to improve compatibility.
  • SQLServer: Faster table structure query (Thanks Micheal).
  • Security:
    • Detect requests from a Cloudflare Tunnel and adjust security posture accordingly.
    • Remove Windows Authentication from Login Screen (If Secured AND Remote (not LocalHost) AND No Connection uses Windows Authentication)
    • Users can change their passwords if using Active Directory/Windows Authentication.
  • Settings: Enabled setting ShowDomainName in WebApp.
  • SingleSignOn:
    • Handle users with large Azure group lists.
    • Moved SSO/SAML validation from UI to Service which is more secure.
    • Retrieve the Azure User Group Names (Extra config required)
  • UrlDisplay: Added explicit option for Image URLs to avoid CORS risks and restrictions.
  • WebRequest:
    • Added ability to retrieve Html and Filter/Parse using XPath.
    • The WebRequest Button action and the WebRequest ProcedureAPI share all functionality.
  • dbFrontManager:
    • Added the dbFront Manager application to simplify the initial authentication.
    • Alerts for invalid configurations or credentials (e.g. Microsoft Online Account).
    • Create/maintain the local dbFrontAdmin user and dbFrontUsers group.
    • Optionally select from a list of valid suggested configurations.

dbFront 1.4.2 - More Procedure API & Bug Bounty

The latest dbFront is still under active development, so we won't say much except to note that it solidifies the Procedure API while also incorporating significant security changes in response to a Bug Bounty we have been running over the past year.  More details to come...

Summary

The full release history for the 1.4.1 branch can be found at dbFront.com/releasehistory

We have been doing a lot of work to secure and enhance dbFront and to update the supporting documentation. If you have time, please consider creating or updating a review of dbFront at one of the following websites: 

  • LinkedIn.com/products/bigideasltd-dbfront?action=recommend
  • g2.com/products/dbfront/take_survey
  • Capterra.com/p/143165/dbFront
  • AlternativeTo.net/software/dbFront (Don't forget to hit the like ♡  button).​​

In place of a review... you can simply like ♡ dbFront at:

  • AlternativeTo.net/software/dbFront

The less effort we spend on sales and advertising, the more effort we can spend on improving and stabilizing dbFront.

Thanks - The Team at dbFront

Image by Kanenori from Pixabay

Continue Reading...


dbFront 1.4.0 - With 37 New Features!

Wed, Jan 08, 2025

dbFront 1.4.0

dbFront 1.4.0 is the new feature release, boasting 37 new features. The blog post published in the middle of November focused on the layout changes in 1.4.0, three days later, we wrapped up the release. dbFront 1.3.2 was never made a feature release, so the features from 1.3.2 are included in this feature release.

Features

Three of the most significant features are:

Layout Changes: We have already covered this in a previous blog post: Layout Changes
Relationship Visibility: The ability to hide and show relationships dynamically. Similar to action buttons and field groups.
Run Procedure: Store procedures can now directly instruct dbFront to retrieve and return information from a web service.


Below is the detailed feature list, quite a few of the features were requested via the Q&A. Buried in this feature list are some very powerful features, some of which we are going to expand upon in future blog posts.

  • Backups:
    • Enhanced configuration backup compares, including viewing all changes over time.
    • Enhanced purge logic to retain at least 120 days of configuration history within 45 backups.
  • Buttons:
    • Added the ability to edit any button's properties from the Table Prefs dialog.
    • Directly set a button width. The default width is 120px.
    • Optionally group buttons, with group names visible or not.
    • Optionally position buttons below their form.
  • Compare: Added "IfContains" and "IfNotContains", compare types. QA:1427
  • Core: Updated multiple 3rd-Party components.
  • Expressions:
    • Added expressions for the parts of the Url. {url(domain)}, {url(root)}, {url(path)}, {url(fragment)}, {url(query)} as optional values to pass to procedures, visibility expressions, etc... QA:1429
  • Fields: Added ability to edit any field's properties from the Table Prefs dialog. QA:1376
  • Import: Added the ability to import PDF forms, similar to Excel or CSV. QA:1083
  • Layout: Added the ability to rearrange the Table elements. (Table Grid, Custom Search Buttons, and Advanced Search), QA:1436
  • Lookups: Allow explicit sorting by View Fields.
  • MySQL: Replaced the MySQL Connector/Net with MySqlConnector to add built-in support for MySQL Server, MariaDB, Amazon Aurora, Azure Database for MySQL, Google Cloud SQL for MySQL, Percona Server and more... No longer requires a separate driver install. QA:528
  • OpenURL: Extend OpenURL so that it can correctly load audio and video.
  • Procedures:
    • Procedures called by RunProcedure and WebRequest can refresh their results automatically and repeatedly. QA:1433
    • Stored Procedures can now make a request and process the result of a WebRequest. QA:1443
    • Updated SimpleTable output format to improve field formatting. (Dates, Blobs...)
  • Relationships:
    • Added dynamic visibility to relationship tabs, similar to buttons and field groups. QA:1008
    • Extended the Multi-Select functionality to compound relationships. QA:1274
  • RequestHandling:
    • Handle callback requests from OAuth and other services via a Procedure. QA:1443
    • Improved help by displaying the expected Request URL in the config dialog.
  • SQLServer:
    • Verify Executable access to stored procedures when saving preferences.
    • Performance Analyzer for Linked Views to help track down view/column problems.
    • Ability to DebugLog SQL Server messages to help monitor performance.
  • Search:
    • Specify if the Advanced search is AlwaysOpen, DefaultOpen, or DefaultClosed. QA:1409
    • Adjust the Search fields to be Single or Range. QA:1408
    • Optionally turn a multi-select into a single select.
  • Table:
    • Ability to configure a "BeforeFormLoadProcedure" to run a stored procedure that can do extra work to prepare the form data before the actual Select for the FormData. QA:1419
    • Display Attachment/Image thumbnails within the grid. QA:1407
  • Testing: Automated client testing using Katalon Recorder (dbFront Site License)
  • WebRequest:
    • Ability to Indent received Json.
    • Ability to receive a file (e.g. PDF) and either view or save it.
    • Ability to set a Request Body including expressions.
    • Ability to set a Request Header including expressions.
    • Ability to set a RequestMethod [Get, Post, Head, Put, Delete]. QA:1092

Summary

The full release history for the 1.4.0 branch can be found at dbfront.com/releasehistory

We have been doing lots of work enhancing dbFront and updating the supporting documentation. If you have time, please consider reviewing or updating your review for dbFront at one of the following websites: 

  • www.linkedin.com/products/bigideasltd-dbfront?action=recommend
  • www.g2.com/products/dbfront/take_survey
  • www.capterra.com/p/143165/dbFront
  • www.alternativeto.net/software/dbfront (Don't forget to hit the [Like] button).​​

In place of a review... you can simply like ♡ dbFront at:

  • www.capterra.com/p/143165/dbFront
  • www.alternativeto.net/software/dbfront

The less effort we spend on sales and advertising, the more effort we can spend on improving and stabilizing dbFront.

Thanks - The Team at dbFront

 

Continue Reading...


Merry Christmas and a Happy New Year!

Tue, Dec 24, 2024

Holiday wishes, from the team at dbFront

It's winter here in Canada, and we get to celebrate a white Christmas, while some around our beautiful globe celebrate a green or even a brown Christmas. As we approach the end of 2024 and the beginning of 2025, we want to thank our loyal customers and those who joined us in 2024 for all your encouraging feedback and support so that we can steadily improve dbFront and make it a better product for all! 

We want to wish everyone a very merry Christmas, and for those working over the holidays, thank you, thank you all!!!

We are working on a few new goodies for dbFront, but they were not quite ready, so we will need to reveal them early next year. See you all in 2025!

 

Continue Reading...


dbFront 1.4.0 - Layout Changes

Thu, Nov 14, 2024

In version 1.4.0 dbFront has added new layout functionality....    You can now rearrange the table grid, advanced search, and search buttons, create groups for buttons, change the placement of the buttons, and change the way the 'Advanced Search' is shown.

Rearrange Grid Items

To reposition the items click on the gear icon beside the form, then click on the layout tab. In the Table section, you can switch the element order by dragging the elements around. This allows you to place the Advanced Search above or below the table grid and the custom search buttons above, below, or in between.

Button Placement/Groups

You will find the Form Buttons section on the same tab. Here you can change the Position of the buttons from the left of the form to below it.

You may also notice in the Form Buttons section you can now hide or display Group Labels. That's right, dbFront has added the ability to make button groups, although the ability to group buttons currently only applies to custom buttons. The Display Custom option allows you to hide or display the group names for the buttons. For detailed information on how to use/implement the button groups, click the following link. Select or Create button groups

Advanced Search

When you click on the Search Fields button you change the way the Advanced Search is seen. The options are Default Open, Default Closed, or Always Open.

Summary

You can view dbFront's release history at dbfront.com/releasehistory

{%freetrial%}

Continue Reading...