Reviewed on 29/12/2016
We Finally Found the Best Fit!
Comments: After chasing technology for years, trying several self-hosted and cloud solutions, we were fortunate to find dbFront. The others had limitations or issues like being bandwidth hogs, requiring tons of ongoing maintenance updates, only offering over-complicated interfaces or their subscription fees kept going up to rates that a non-profit can't justify. Our goal was to make our data available to all Internet Users for searching, displaying, sorting and printing/exporting to CSV or PDF - - really what you would think would be a simple project. It turned out to be quite the daunting task. dbFront and their Team has changed all of this for us. We are finally able to utilize the data from our SQL database, displaying the records from within our website, using dbFront's web application and features. Using dbFront, we use can display all of our records in any order, based on any filter, add action buttons for printing, format our report templates and more. We have an Administrative panel where we can edit or add records, an Administrative panel for our Public view, and our end product for Internet Users. The interface is simple, yet very powerful. We're still learning the interface, but completely excited and relieved to find dbFront. You can choose to build a super simple Table/Form page, displaying your records in table format in the top panel, with the details for each record in the bottom Form, and a simple button to print details. You can also add multiple reports based on the criteria you set up in the back-end. You have the ability to modify both the Table and Form views. For example, you decide which fields (columns) to include in your Table, the order, and the field titles, along with the same type editing allowed for your detailed Form view. You can also add action buttons for printing and grouping. The features for "Search" and "Column Sorting" are automatically built-in for your End-Users. An experienced Database Administrator could be up and run in a very short amount of time. Less experienced Users can accomplish the same, taking a bit longer to get their public view where they want it. Bottom line: The more we use dbFront, the more excited we get. I see this as being a top contender for those in need of displaying/formatting their data on public websites, or for those in need of offering a company-wide record editing application. We are very happy to have found dbFront and look forward to years of utilizing this application.
Pros: Ease of use and the support can't be beaten.
Reviewed on 13/12/2017
A very quick and efficient means to put a front end on a database
Comments: We have our front end for the dozen or so data marts we will be setting up. With how easy it is in DB Front to copy the setup from one database in the application to another we have 100% consistency in approach in between all the data marts which means we will spend less time navigating and understanding what we're looking at and more time producing. Also all of this has been achieved under a tight deadline and requires almost no programming knowledge to use or setup.
Extremely easy to set up and update.
Extremely easy to have multiple databases use the same settings.
Once connected to a database it does a pretty good job at knocking together a front end without the user doing much more than classifying tables.
Adding in the functionality of stored procs is very easy. Our team is working on data warehousing solutions and we have moved to a model where each department gets their own datamart. This means many databases all needing to share standards and best practice. We tried putting an Access front end on the process but quickly gave up seeing how complex and time consuming it was. DB Front, on the other hand, was installed and working within 30 minutes and has gone from strength to strength. Do we have an application as customised as we could get with Access? No. But the Access project was looking like months of work and this took hours. The end result may not be perfectly customised to our project but it does what we need it to (help with consistency and usability) and does it without causing us any grief. Of course, being in development, we managed to find a few niggles with the software (such as we had more databases than it could display in a list on our dev server) but with a quick email we had someone who knew the software inside out looking into the issue and had a beta release based on our own issue during the couple of weeks we have been working on this.
Cons: There are things to be refined like limiting dropdown lists to subsets of records...minor details and I'm sure part of a future update.
by dbFront Works on 14/12/2017
Thanks for the great review Alex.
Reviewed on 21/11/2016
Excellent - It's what the database community has been looking for for years!
Quite simply, this product lets you use the power of a database to maintain & report on your data without the need for any front end programming. Providing you use foreign key constraints to maintain your data relationships dbFront will do the rest for you. It provides you with effective control over user authentication & database access and auditing. You can determine which columns to display or hide, which to allow to be read only and which are required. You also have control over the sequence in which columns are shown on the screen. It handles lookup tables well with the ability to sequence the lookup drop down data in any sequence you like. If you want to add business logic into all of this you can always utilise back end database triggers and the dbFront provided Action Buttons. It allows you to easily define who can Read/Update/Delete rows on any table. I needed dbFront because although I am an experienced database designer/developer my user interface development skills are sadly way out of date. dbFront allows me to provide a standardised front end for my users to maintain and report on their data.
The support I have received from the dbFront team has been excellent.
Pros: It's ability to allow you to use the power of a industry standard relational database solutions without having any programmng skills. Essentially, it makes Access and Spreadsheet solutions obsolete and imposes conformity and data integrity across your data.
by dbFront Works on 21/11/2016
Thank you for the glowing review Colin! As a former DBA, this is exactly why I built dbFront.
Reviewed on 10/05/2018
Great product for a low price vs the competition
Pros: dbFront has been a crucial piece in my push to redesign the way our engineering department views and updates test data across our worldwide SQL footprint. The support team is always extremely responsive to any issues I've run into and typically has a resolve for me very quickly. Not only is it easy to use, but our engineering team LOVES it compared to the homebrew tool they were using before to view/update/query test data.
Cons: There are some minor things that I have put in feature requests for, but nothing that will dissuade me from continuing to expand our dbFront footprint.
by dbFront Works on 15/05/2018
Thank you very much Jamie. Your feature suggestions are very helpful and will be added to dbFront.
Reviewed on 24/05/2017
Where has this been all my life?!
Pros: This is one of the easiest to roll out software packages I've ever used. Extremely useful to capture data into an actual database. Before DbFront, my users liked to create hundreds of spreadsheets or customized Access databases. Now we can centralize everything on our SQL Server which is backed up, and standardized
Cons: Would be nice to be able to customize the user interface a bit more. One problem is that you can only have two level relationships. So you can select say Record A to show related Record Bs and then select a Record B and show related Record Cs. You can still access these other relationships, but you need to go to different drop-downs and areas. Everything has to be related to Record A to show up on the main page. In our use case that would be helpful.
by dbFront Works on 13/06/2017
Thanks for the review Joe. If you could mock up in a high-level way, how you might see more levels of relationships interacting on the same screen then I can put that request on the road map. I understand your desire to cut down on excessive user navigation.
Reviewed on 13/03/2019
Sweet Merciful Zeus
Comments: I've already moved a few powerapps over to dbFront. Super easy to whip up a front end for a user and tie that into data analytics.
Pros: If anybody has ever written a java based frontend for a database.... we now have DbFront. Its dynamic. How has this not existed? This thing saves me nothing but time and money.
Cons: Doesn't work great with portrait mode, otherwise this software is money.
by dbFront Works on 29/03/2019
Thanks for the great review. Let me know if there is a specific feature you see missing.
Reviewed on 29/06/2016
Comments: Great product.. Needed assistant connecting to my domain and azure and support was awesome. Software is an excellent solution for a quick way to have a front end to your DB.