Yesterday, 23rd October 2026, was the inaugural Data Day Edinburgh conference. With Data Scotland taking a break this year, it was great to see a…
Category: Data Science
PostgreSQL is great but it does not do everything out of the box. Here are some options you can activate and extensions you can install…
For data science Postgres is rapidly becoming the go to database. As well as being highly scalable and durable, Postgres goes beyond being a SQL…
A lot of datasets include rows with missing values. These values rows either need to be removed or the missing values need to be approximated.…
Databricks comes with JDBC drivers installed by default. Databricks has an ODBC driver available to allow you to connect to Databricks. However despite the pyodbc…
UV is a powerful package manager for Python. UV can supplement or even replace other tools like pip, conda, and venv. However it works a…
How time flies, Data Scotland 2025 was another great event. Here are the things I learned about this year. Where possible I have linked to…
Apache Druid is a very powerful, scalable Online Analytical Processing (OLAP) database system. However getting started with it can be a little intimidating for some.…
I recently attended Data Scotland 2024 and attended a number of interesting talks. Here are some takeaways. Where possible I have linked to the talk…
When you ask Databricks to write a JSON file, you may be surprised by the results. Rather than writing a simple individual JSON file, instead…