28 August 2024
by wpAdmin
0 comments
I’ve been reacquainting myself with MS Access recently. Since I seem to be mainly in a Windows mode at the moment and since I have an Office365 subscription, I’ve got access to Access and it provides tools for building an … Continue reading
27 March 2021
by wpAdmin
0 comments
Spring has been here for a while now, things are growing and I’ve got to get a move on with keeping tabs on my garden data. If I want to be able to look back and, for example, see how … Continue reading
3 September 2020
by wpAdmin
0 comments
Following yesterday’s post, I’ve now started building my sqlite3 database (now with the working title of florafolio) and importing my data. Since I had source data in various spreadsheets and spreadsheet friendly formats (Google Sheets and CSV respectively), I decided … Continue reading
2 September 2020
by wpAdmin
0 comments
Just over a year ago, the MyFolia website closed down. I’d been using it to capture information about my gardening exploits – what plants I had, how they were growing and harvest volumes, etc – for over a decade. Fortunately, … Continue reading
22 August 2013
by wpAdmin
0 comments
A WordPress question I still haven’t been able to find a decent answer to is how to keep the backend database, particularly the wp_postmeta table, under control. It currently weights in at 150MB and growing; tiny compared to modern storage … Continue reading
5 March 2013
by wpAdmin
0 comments
Today’s tasks have included taking a list of identifiers and names and converting them into a series of SQL statements to create, populate and drop temporary database tables. If I just had one or two lines in the form: 56,DataIdentifier … Continue reading
12 February 2013
by wpAdmin
0 comments
One of the challenges of working with databases is that the structures required to store data for maximum flexibility sometimes end up being an obstacle to providing quick answers to routine questions. I have been finding that at work recently, … Continue reading