Blog: Endpoint

213 blogs updated: 33 min. ago
Building Rasters in PostGIS
In a past blog post I described a method I'd used to digest raw statistics from the Mexican government statistics body, INEGI, quantifying t...
02-10-2018 18:40:55 Endpoint PostgreSQL
Systematic Query Building with Common Table Expressions
The first time I got paid for doing PostgreSQL work on the side, I spent most of the proceeds on the mortgage (boring, I know), but I did ge...
20-06-2018 04:15:28 Endpoint PostgreSQL
Regionation with PostGIS
Recently a co-worker handed me a KML file and said, in essence, "This file takes too long for the Liquid Galaxy to load and render. What can...
09-02-2018 03:24:45 Endpoint PostgreSQL
Inserting lots of data efficiently in Rails + Postgres
This is going to be a very short post about a simple solution to the problem of inserting data fast when you really have a lot of it. The pr...
05-12-2017 07:49:02 Endpoint PostgreSQL
Working on production systems
(Not as easy as it looks) Photo by Flickr user 'edenpictures' As consultants, the engineers at End Point are often called upon to do work on...
14-11-2017 03:46:12 Endpoint PostgreSQL
Using PostgreSQL cidr and inet types, operators, and functions
A common problem in database design is how to properly store IP addresses: They are essentially positive 32 or 128 bit integers, but they're...
13-11-2017 21:10:44 Endpoint PostgreSQL
Disaster Recovery - Miami to Dallas in one hit
Hurricane Irma came a knocking but didn't blow Miami away. Hurricanes are never fun, and neither is knowing that your business servers may b...
13-11-2017 14:31:50 Endpoint PostgreSQL
AngularJS is not Angular
Why I'm doing this? I often see that people use AngularJS and Angular names interchangeably. It's an obvious mistake for someone familiar wi...
13-11-2017 07:58:07 Endpoint PostgreSQL
PKIX path validation failed - Debugging
I recently ran into a case working on an application with a PKIX path validation error on a site that had a valid certificate. I was able to...
13-11-2017 01:24:35 Endpoint PostgreSQL
Liquid Galaxy at ASTC 2017
End Point is pleased to be participating in ASTC 2017, alongside our partners BWC Visual Technology. ASTC, which stands for the Association ...
12-11-2017 18:45:10 Endpoint PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.