revtothelimit - motorbike forum

Just want a simple tool where I can create a database, or use one it comes with.
Then create a table. Then import data from a CSV file.
Then run my own SQL to crunch the numbers

Tried a few but so bloody complex or only a tool to access a remote DB
Tried SQL Server. What a nightmare

So, any simple jobbies out there?

Only need it once so a short trial is ok

Ta

Personally I have some old copies of MSAccess knocking around so I'd probably do that. Googling, LibreOffice Base is probably a good alternative but I've never used it.

I imagine you can load CSV files into ChatGPT and tell it what you want. But your User Requirements provided so far have been rubbish. so eff knows if that's suitable. Is this so you can track the number of pesetas left in your wallet?

MS Access should do it, however I suspect you could probably do most of it in Excel if it's just a single table with no relationships.

I'd probably spin up a CloudSql instance in https://cloud.google.com/, 5 mins to create and the same to start a free tier SQL DB, there are Postgress and MySql types or MongoDb derivatives if your a NoSql fan.

Otherwise install MySql locally and run things via the cli or install dbadmin as a UI.

I would agree with the comment about using a spreadsheet and have used Libre office Calc with some interesting macros behind the data. Syntaxes such as Python Basic or Javascript are possible if you are familiar with them. Essentially the same as Excel. If you are the only user there is less need for data entry validation or concerns about consistency of relationships, scope etc. Expertise can be found on WWW but unfortunately documentation tends to be patchy with this open source stuff. Try https://help.libreoffice.org/latest/en- ... _help.html

If you need a relational database Libre Office also offers that but it was beyond what I needed so I haven't tried it.

Power BI is free and pretty good. The back end works like OLTP and the front like OLAP, should work fine if it's mainly for analysis and not transactional.
Needs WIndows though as it uses MS SQL server components.