News for hackers. Stuff that matters.

A comment on Looking Back at Postgres. Parent comment

Re:Looking Back at Postgres by mycall on Monday June 15, 2020 @07:46PM (#23534390)
Since this is dBase file format, does this mean shapefiles can do more than alternative formats, like geoJSON?
[ Parent | on HN ]
Re:Looking Back at Postgres by aasasd on Tuesday June 16, 2020 @06:43AM (#23537620)
I have exactly the right link to answer this: http://switchfromshapefile.org

Funny enough, two popular contenders are built on SQLite.

[ Parent | on HN ]
Re:Looking Back at Postgres by Stratoscope on Monday June 15, 2020 @08:01PM (#23534483)
That's an interesting question. In practice I've found it to be the other way around - especially the ten character limit on .dbx column names. If your incoming data has a field named "Population in 2010" you have to map it to something shorter like "PopIn2010". Not a big deal but it gets annoying.
[ Parent | on HN ]