[postgis-devel] postgis_letters in project tree?

Paul Ramsey pramsey at cleverelephant.ca
Thu Jan 27 14:45:57 PST 2022


Challenge accepted, all just one function.

https://gist.github.com/pramsey/2020ef463a8880edc7e23c56420d7df8

> On Jan 27, 2022, at 2:08 PM, Darafei Komяpa Praliaskouski <me at komzpa.net> wrote:
> 
> I like this way. Believe we only need one function really.
> 
> (I called this ST_GeomFromText in my head for a bit...)
> 
> пт, 28 сту 2022, 00:38 карыстальнік Paul Ramsey <pramsey at cleverelephant.ca> напісаў:
> Here's the two functions. I think putting these into the default postgis extension makes sense, they are small and then we have letter magic available for doco etc wherever we want.
> 
> https://gist.github.com/pramsey/2020ef463a8880edc7e23c56420d7df8
> 
> P
> 
> > On Jan 27, 2022, at 10:32 AM, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> > 
> > Using base64 encoded twkb, i can get the letters set down to a 22K function. So, I think maybe this just goes into the main postgis extension. (Assuming you're OK with my minimalist anglo no-special-font handling approach.)
> > 
> >> On Jan 27, 2022, at 9:29 AM, Martin Davis <mtnclimb at gmail.com> wrote:
> >> 
> >> 
> >> On Thu, Jan 27, 2022 at 9:03 AM Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> >> I'm thinking of converting the letter/font table into a function with a fixed collection of letters, so that an install involves just two functions ST_GeomFromLetter(letter) and ST_GeomFromWord(text). ST_GeomFromLetter can be expanded over time to include additional letters for other language charsets. That matches the capabilities of the system to the needs.
> >> 
> >> That sounds like the simplest approach.  Nice to avoid needing a table.  
> >> _______________________________________________
> >> postgis-devel mailing list
> >> postgis-devel at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> > 
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel



More information about the postgis-devel mailing list