Re:Local-first software: You own your data, in spite of the ...
by sdoering on Friday May 03, 2019 @06:30AM
(#19817080)
I second that. SQlite is great. I had millions of lines in there and did not hit limits that were blocking me from doing analysis work in python based on the data in SQlite.
So parent should probably be fine with a solution like this.
Portable, local and without the server configuration hassel.
Re:Local-first software: You own your data, in spite of the ...
by pbhjpbhj on Friday May 03, 2019 @08:13AM
(#19817662)
If you use LibreOffice then you can make a spreadsheet into a "database source" and query it with SQL. That seems like a good interim, you can move sheets and make them external tables as you grow in confidence/knowledge.
At least you could 10 years ago, very easily (it was OOo.org I was using then I think) - I made a simple customer record system just 4 or 5 tables but the address "table" was a kind-of view of the spreadsheet for email-merge.
Presumably Excel and others do this too.
Re:Local-first software: You own your data, in spite of the ...
by chicob on Friday May 03, 2019 @08:56AM
(#19817955)
I do use LibreOffice. There seems to be some way of using SQL to access Base data, but I still didn't explore that.
Re:Local-first software: You own your data, in spite of the ...
by chicob on Friday May 03, 2019 @08:52AM
(#19817932)
Thanks. I'll give it a try. I chose MySQL because I knew there were Python libraries I could use.
Re:Local-first software: You own your data, in spite of the ...
by justinclift on Friday May 03, 2019 @10:48AM
(#19818920)
Cool. Python has libraries for practically everything. :)
The SQLite libraries seem to be built into Python, so nothing extra to add:
https://docs.python.org/2/library/sqlite3.html
https://docs.python.org/3/library/sqlite3.html
And the PostgreSQL equivalent:
Hmmm, there seem to be several PostgreSQL Python libraries around, all in active development.
You'll probably be fine with SQLite though. :)
https://sqlitebrowser.org
https://a-gentle-introduction-to-sql.readthedocs.io/en/lates...
SQLite is a bunch easier to get up and running than MySQL, and the data is all in one file you can copy around. So, easy to backup. :D
If you do eventually hit it's limits, it's big brother is PostgreSQL, which is a really powerful database system. :)