What desktop databases are used now?

Richard Teasdale
Richard Teasdale used Ask the Experts™
on
Hi: I have been a member of EE for a number of years now with much appreciated help (that's especially you pcelba and olaf)  and now I want to hand over my databases to somebody new. Over the years I have used Lotus Approach (brilliant for finding on the fly and copying crosstabs) Paradox (fantastic programming) vfp (great for creating executables); all essentially drawing data from SQL databases, chewing up the data and spitting out reports. And all now defunct or nearly so. SO what do the youngsters use now to interrogate SQL? Just what great software has replaced these titans? I want to train up a youngster to take the company forward; just what should he be learning?
Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi Clayton

Forget about desktop databases. Youngsters are using mobile devices and social networking. They don't care about databases and they ignore paper reporting :-).

OTOH, Visual FoxPro is still alive and some (partly compatible) successors are on the horizon - namely Lianja and xBase++ but you have to decide whether this is the right way or not. Even dBase (sold several times) has some new versions this time.

Development moves to the cloud so the main stream is web based applications which you can access from any device connected to internet. Lianja offers such possibility but it is still a small cap and you never know what happens the next day. But they are several years on the market already. Alaska with xBase++ is here even longer.

But cloud offers much more and you may select from many platforms free or paid, widely supported or less known. The new planned development tool should follow your goals. Fortune 500 companies cannot accept Lianja as the development tool but you have to use C# (Visual Studio) and SQL Server or even Oracle and SAP... Non-profit organizations can accept much wider range of tools.

You can look here what are the most used languages today: https://www.tiobe.com/tiobe-index/

I am going the C#, SQL Server and ASP.NET way now. My customers require it. I am also interested in Python.  

PHP + MySQL seems to be easier to learn.
I should also mention MS Access which is stable enough today but I still cannot say it is professional tool as it has certain deployment drawbacks.

Of course, any development platform change requires many hours of learning and the question is whether to spent this time in learning or wait for AI which will replace us sooner or later... Maybe for that reason I still know almost nothing about noSQL databases, big data processing, IoT, Linux etc. etc.  BTW, Linux seems to be my nearest point of interest...

Regards
Pavel
Richard TeasdaleFinancial Controller

Author

Commented:
Thanks - as always - pcelba. I am planning to retire in a few years so hopefully you will hear less of me! I am a linux nerd and am working on LAMP solutions to archiving my databases. However we are still tied to MS SQL or windows based programs which I need to draw on. I am an accountant by trade  (you will have guessed I am no IT geek) and get frustrated with the accounts packages (not least the ridiculous cost) so need to persevere. I am taking on a young accountant and together we are going to build vfp programs that should run unattended after me; none of which could have been done without you (and Olaf, of course). If we never speak again, thank you very much for everything and good luck without whatever comes your way.
Richard TeasdaleFinancial Controller

Author

Commented:
Thanks again
I wish you all the best in the upcoming transition! This is also my case in a few years but I still have many things to do... BTW, Ed Marzo has been active here till 80 with his FoxPro program.

Olaf is still active, namely in Microsoft forum: https://social.msdn.microsoft.com/Forums/en-US/home?forum=visualfoxprogeneral

Pavel

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial