Coding language for databases

Rulenine

Estimable
Mar 20, 2016
2
0
4,510
Hey all!

After spending a lot of years building computers and working with hardware, I want to start focusing on the software side of stuff. I'll be starting with VBA and building some of that basic programming knowledge via program macros in excel, get used to the function, format, and style of coding, but eventually my goal is to build a database with functional UI and executable tasks. Ideally, the database would allow me to store ideas, thoughts, concepts, information, and formulas and connect them via keyword analysis or manually and would have a functional UI. What would be the optimal coding languages to learn so as to one day reach this goal?
 
Solution
I would say, why reinvent the wheel. There are plenty of open source database engines. Use one of them. The schema is the important thing. That is the way the data is stored. Access would be via SQL, for example... "select * from ideas where keyword in ("forum", "hardware", "ivy league")" ... SQL has ANSI standards. Again, why reinvent the wheel. Utilize open source and leverage on it.

kanewolf

Judicious
Moderator
I would say, why reinvent the wheel. There are plenty of open source database engines. Use one of them. The schema is the important thing. That is the way the data is stored. Access would be via SQL, for example... "select * from ideas where keyword in ("forum", "hardware", "ivy league")" ... SQL has ANSI standards. Again, why reinvent the wheel. Utilize open source and leverage on it.
 
Solution

USAFRet

Illustrious
Moderator
but eventually my goal is to build a database with functional UI and executable tasks

Why?
There are many, many database platforms out there.
Microsoft, Oracle, open source...

Starting from where you are: "basic programming knowledge via program macros in excel", you are a decade or more away from building something 'new'.