What desktop databases are used now?

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!
Richard TeasdaleFinancial ControllerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
pcelbaCommented:
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
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Richard TeasdaleFinancial ControllerAuthor 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.
0
 
Richard TeasdaleFinancial ControllerAuthor Commented:
Thanks again
0
 
pcelbaCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.