But different in that it has as more powerful programming language, supports SQL and other back end databases and has a version that can be compiled. Also similar in that it has built-in features for user to do data-entry, exporting, reporting, and printing. Similar to FileMaker in that it combines a database server with a form-building tool and a proprietary programming language.
It's the best RAD tool from desktop to web that currently exists. FileMaker is a full-blown relational database supporting 1 million tables per file and up to 8TB in a single database.
#BEST DATABASE SOFTWARE WINDOWS FULL#
Also has full JSON and support for linking to SQL tables.įileMaker has always been aimed people who want to get started building databases without hiring professional developers to get started. Has built-in features for user to do data-entry, exporting, reporting, and printing. It combines a database server with a form-building tool and a proprietary programming language.
So long story short what would be the best frontend program that would preferably work with SQL and allow for the functions I specified? A little explanation as to why you think a specific program is best for the job would be great!įileMaker is a relational database client server database that run on Mac, Windows, iOS, and web. I'm am storing part names/SN, ID addresses, website urls, and the part pictures. I'm thinking about using SQL server to do the backend, but that is subject to change based on what people would suggest. I need some help finding a frontend program that would be very secure and easily manageable to allow for proper functions like: searching, exporting to excel, emailing, and displaying images from records. I am not a CS guy, I can manage, and I do know a few languages(C, Java, VB), but I don't have the background to present something that I think would be adequate.
#BEST DATABASE SOFTWARE WINDOWS HOW TO#
I know SQL enough to manage writing the backend, but I have no idea how to begin writing the program for a frontend, and quite frankly I think it will be much better if the front end was written by a profession to allow for proper security and functionality.
I have currently thrown together a quick access database (I know access is frowned upon) to use as a temp until I figure out what is the best thing to do at this point. There will only be a couple thousand data entries with images as well. I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive.