Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
durkie
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
151.
▲
by
durkie
7y ago
How about something like Tegola? https://tegola.io/
152.
▲
by
durkie
7y ago
They are called Citylab, after all.
153.
▲
by
durkie
7y ago
I'm in a similar boat, looking to generate my own vector tile static images (basically raster tiles with fractional zoom levels). I use a fair amount of these, and there's no service that lets you cache them (of course). Seems lik
154.
▲
by
durkie
7y ago
Hey -- I tried a few emails to matt@ several months ago and never heard a response (even to reject me). Is this a functional email address?
155.
▲
by
durkie
7y ago
I appreciate it! Postgis I think is still quite good, it's just computationally intense for some operations (which I suspect geomesa might run in to as well -- I think a lot of gis libraries make use of gdal and proj libraries under th
156.
▲
by
durkie
7y ago
Thanks! Partitioned and foreign tables look quite interesting -- I'm at the point where I need to scale the database compute load (with write access) across many nodes, but coordinating those nodes has seemed challenging with rails. An
157.
▲
by
durkie
7y ago
Yes -- it's a good talk, but it focuses mostly on tricks you can do (spatial indexing, geometry subdividing) on the PostGIS side to make lookups/calculations faster, but discussion of actually scaling to multiple databases is a bi
158.
▲
by
durkie
7y ago
what are modern practices for scaling rails apps when the database is the bottleneck? I have a GIS-heavy app that is built with rails, but leans on PostGIS a lot for the heavy computation. Simply getting bigger and bigger database instances
159.
▲
by
durkie
7y ago
Is the radiative cooler really just an aluminum disc painted black? Why this material versus some of the other designs out there (some groups have made these out of wood, others with glass microspheres in polypropylene, etc)
160.
▲
by
durkie
7y ago
You are right. I've been dealing with this personally with PostGIS and storing large geometries. Ideally you split the geometries up in to many smaller geometries (using a built-in function), and it's much faster to calculate inte
161.
▲
by
durkie
7y ago
Can't they just not buy it? Lots of cheaper alternatives out there. Seems no different than a fancy watch or pen.
162.
▲
by
durkie
7y ago
I've had pretty good luck with using table triggers to update materialized views and make everything "automatic". A little more work up front, but pretty easy to forget about it once it's in place.
163.
▲
by
durkie
7y ago
What's partisan about it?
164.
▲
by
durkie
7y ago
I don't understand your point maybe. The atmosphere can't reflect the radiation back -- it is unable to absorb energy in those ranges of wavelengths. The radiation passes through the atmosphere in to space unhindered.
165.
▲
by
durkie
7y ago
the energy mix of electric grids everywhere is changing rapidly to include more renewable technologies, and especially so on islands. puerto rico's grid was in quite bad shape, but it was also originally designed around importing most
166.
▲
by
durkie
7y ago
for what it's worth, ST_AsGeoJSON lets you specify decimal precision as an optional argument, so you at least don't have to write a truncating loop. Another good option with many polygon geometries is Base64 encoding the output of
167.
▲
by
durkie
7y ago
It's about to be me too. GT grad and likely moving to Bay area soon.
168.
▲
by
durkie
7y ago
Georgia is an interesting outlier here: they introduced the HOPE scholarship in the 1990s to allow any in-state (already lived there for at least a year) student free tuition at a state school as long as they maintained a 3.0 GPA, all funde
169.
▲
Nan Gates and Flip-Flops
(youtube.com)
3 points
by
durkie
8y ago
|
0 comments
170.
▲
by
durkie
8y ago
Thanks for making this! I've got a PostGIS app that is starting to groan a bit with a Heroku Standard-0 database and I've been trying to weigh my options for next step.
171.
▲
by
durkie
8y ago
I think under the construct that computer code is a means of expression protected under the first amendment, the US government requiring Apple to implement a code change would be considered a form of compelled speech.
172.
▲
by
durkie
8y ago
The "transparent aluminum" thing really needs to die. By the same logic you could just call normal glass "transparent silicon"...
173.
▲
by
durkie
8y ago
super cool! are yall hiring materials scientists? :)
174.
▲
by
durkie
8y ago
good lord he's unwatchable. skip to 7:00 for something somewhat real.
175.
▲
by
durkie
8y ago
There are homemade soda carbonators for sale on ebay that can be a pretty good deal. Something like this is what I have: https://www.ebay.com/itm/Kegman-Seltzer-Making-Bottling-Kit-... The price is basically the same a
176.
▲
by
durkie
8y ago
PSA: those using Robinhood for trading, they use the FIFO/first-in-first-out method for determining your cost basis when you sell. This can have unexpected tax consequences. https://support.robinhood.com/hc/en-us&#
177.
▲
by
durkie
8y ago
Atlantan here. I got a bottle of their hot sauce with my CSA and it's really good. I'm not normally a big vinegar-sauce guy, but their recipe has lavender in it and it's pleasantly funky. Recommended!
178.
▲
by
durkie
8y ago
non electrek link if you're questioning the source: https://reneweconomy.com.au/tesla-big-battery-turns-one-cele...
179.
▲
by
durkie
8y ago
what's wrong with the term? seems like there can be more than one "nude".
180.
▲
by
durkie
8y ago
you'd be real close to one of tulsa's best features: https://www.youtube.com/svseeker -- dude's building a giant scientific research boat in his front yard and will host just about anyone that wants to help h
More ›