-
Recent Posts
- 009 Postgres Command Line : psql : Altering the stated language – lets try Python
- 008 Postgres Command Line : psql : Another function example
- 007 Postgres Command Line : psql : Create a function that returns a single value
- 006 Postgres Command Line : psql : Identify definition of a Function
- 005 Postgres Command Line : psql : Create a User Defined Function and Identify its creation and then Drop it.
- 004 Postgres Command Line : psql : Create a spatially enabled table
- 003 Postgres Command Line : psql : List all databases in a Postgres Instance
- 002 Postgres Command Line : psql : Enabling extensions (PostGIS) to a database
- 001 Postgres Command Line : psql : Getting Started with Postgres
- 000 Postgres Command Line : psql : Useful RESOURCES Link to Github Cheat Sheet AND live on the web SQL excercises
Archives
- February 2019 (11)
- December 2018 (1)
- November 2018 (1)
- September 2018 (2)
- August 2018 (1)
- May 2018 (2)
- April 2018 (1)
- March 2018 (6)
- February 2018 (2)
- January 2018 (1)
- November 2017 (4)
- October 2017 (2)
- September 2017 (3)
- August 2017 (5)
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
- January 2014 (1)
- September 2000 (1)
Category Archives: Open Source
MS Access Function – import all CSV files from a directory with the same structure into a single table
This is a really nice function that can be used to place all data from multiple CSVs (with the same structure) into a single table. Here I use the Ordnance Survey’s excellent Code Point data set that gives postcodes in … Continue reading
Posted in Address Matching, All, Geographical Information Systems, GIS, MS Access, Open Source, VBA Code MS Access
Comments Off on MS Access Function – import all CSV files from a directory with the same structure into a single table
nuBuilderPro – Import csv into a table of your application MySQL database (Its very easy)
I don’t know about you but for me its pretty rare to start an application without any information. At the very least there may be lookup tables or you have information collected in a spreadsheet. Thus when I came to … Continue reading
Posted in All, nuBuilderPro, Open Source, Personal Development
Comments Off on nuBuilderPro – Import csv into a table of your application MySQL database (Its very easy)
The Gunslinger and the Indian
There’s a fight on your computer over a girl called Planned Obsolecence I get that you need to update software periodically and I definitely want to see software developers paid an appropriate amount but what happens when no one can … Continue reading
Posted in All, General Opinion, Open Source, The future of software
Comments Off on The Gunslinger and the Indian
QGIS – Free GREAT Digital Mapping Software
A map showing winds over the Atlantic Looking for a desktop digital mapping package? You really need to check out QGIS it is an absolutely excellent open source geographical information system. At the time of writing the latest version was … Continue reading
Posted in All, Digital Mapping, General Opinion, Geographical Information Systems, Open Source, QGIS General
Comments Off on QGIS – Free GREAT Digital Mapping Software