Category: DataBases

At the end of the last post I’d found that the original NZ regional dataset had changed. I was also finding it slow working in Google Sheets as the interwongle seems to be slow with so much demand. So I decided that I’d start working locally. My current process is to get the data, manipulate

After AutoCad, that had LISP, where you could write some simple code and get some useful tailored tools that helped your efficiency, I find Revit tailoring a lot more difficult. It is more sophisticated and so programatically there are more challenges, so the code needs to be a bit more complex, but some simple Keyboard

After playing with Azure I was in the MS(Microsoft) headspace and while browsing the net I came across a website with a .asp extension, so I thought i’d look at building a website with ASP.NET Core. So after figuring out the difference between ASP.NET and ASP.NET Core, core being the updated method which is cross

In the last article I tried linking to my VPS MySQL & PostGres databases and couldn’t. On a test DB site I could connect but to maintain the free DB I needed to log in each week, so I decided not to proceed with that. So, this time around I’m going to try and use

I have played with Power BI and Data Studio (DS) is Google’s equivalent, and its Free. Since I’ve been playing with GlideApps I have been working in the Google Docs environment with Sheets and Google App Scripts (GAS) and find the Google environment is versatile and has lots of features. An extension of learning to

I had seen Airtable pop up a number of times. I thought it was just another team tool, like Notion & ClickUp, and it is, to an extent, but its also a DataBase , but a friendly one that you can share. It allows you to create tables and link the tables together. Also to

Obvibase database with Google Sheets I was thinking about my expenses Form/Sheet process Spending Tracker that I’m very pleased with. A method to capture my spending. My concern is that the sheet will bloat over time with older records. I was surprised that one of my big sheets in Excel could not be opened in

I thought I’d have a look at QGis again now that it has been updated. I’m always wow’d by what people can do with the GIS mapping. Unfortunately for me I’m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools. As QGis and

Macro Tools Following on from Macro productivity tools using AlternativeTo I came across: SikuliX automates anything you see on the screen of your desktop computer running Windows, Mac or some Linux/Unix. It uses image recognition powered by OpenCV to identify and control GUI components. This is handy in cases when there is no easy access to

A regular expression, regex or regexp A regular expression, regex or regexp is, in theoretical computer science and formal language theory, a sequence of characters that define a search pattern. Usually this pattern is then used by string searching algorithms for “find” or “find and replace” operations on strings, or for input validation. From Wikipedia.