3 ms·
Early in my IT career, I did a lot of MS Access development, and MS Access gave me a huge advantage (at the start) of the company my cofounders and I started an
by F_J_H 10y ago
Early in my IT career, I did a lot of MS Access development, and MS Access gave me a huge advantage (at the start) of the company my cofounders and I started and sold. Although it certainly had it's limitations, MS Access did meet a lot of needs for SMBs, much as how you describe FoxPro did/does.
If you want something similar with respect to ease of development and deployment, check out Oracle Application Express, or APEX, which comes with the database as a no-cost option. A good quick summary of APEX can be found here: https://insum.ca/about-apex/ https://insum.ca/about-apex/ (Disclaimer - I work with Insum.)
Most on HN seem to really dislike Oracle, which is not completely unwarranted. However, a framework like APEX can enable you to stand up CRUD apps very quickly, and Oracle has a free version of the database (Oracle XE, which includes APEX), that will easily meet the needs of many SMBs. I've gone through a few different "Build an X clone" type tutorials online to learn both python and JavaScript frameworks, and in each case, building the same thing with Oracle APEX takes a much less time, and is way easier given the declarative interface.
APEX is not for everyone and won't solve all your problems, but for those looking to modernize MS Access and FoxPro apps, it's worth checking out.
- omouse 10y agoHave you used LibreOffice's equivalent, Base?
- F_J_H 10y agoNo, but will look into it. I'm guessing it's not web/browser based?
- jsymolon 10y agoCorrect. "old school" computer based DB and front end. Think of it as the Open Source Access DB.
- omouse 10y agoReporting back, I started setting up a Base database for invoices, customers and products/services. It wasn't too bad to work with and you do get the power of SQL underneath. I think it generates a web interface so it's basically CRUD apps without writing any code, just point and click hooking up of components with fields and tables.