RustProof Labs

@RustProofLabs

Databases (Postgres), GIS (PostGIS), cybersecurity, and jumping out of airplanes are my favorite things.

Colorado
Vrijeme pridruživanja: prosinac 2012.

Tweetovi

Blokirali ste korisnika/cu @RustProofLabs

Jeste li sigurni da želite vidjeti te tweetove? Time nećete deblokirati korisnika/cu @RustProofLabs

  1. proslijedio/la je Tweet
    31. sij
    Poništi
  2. proslijedio/la je Tweet
    30. sij

    pgWikiDont: Check You're Not Doing Bad Things in Postgres -

    Poništi
  3. 30. sij

    Woot! Excited to put to_markdown() to use! 🤓

    Poništi
  4. proslijedio/la je Tweet
    26. sij

    PostgreSQL 13: Sort method and JIT info per parallel worker in Parallel query EXPLAIN ANALYZE.

    Poništi
  5. 25. sij

    Stealing other people's creative work is bad karma

    Poništi
  6. proslijedio/la je Tweet
    23. sij

    Excellent commentary about a hard problem.

    Poništi
  7. 24. sij
    Poništi
  8. 20. sij

    I got tired of struggling to find the units for an SRID... wrote a view to create a units column from spatial_ref_sys.proj4text in Need SRIDs in Feet? No problem!

    Screenshot from DBeaver shows the results from the following SQL query using the view created in the references GIST. 

SELECT srid, units, srtext
	FROM public.srid_units
	WHERE srtext ILIKE '%Colorado%'
		AND units = 'Feet'
;
    Poništi
  9. 18. sij
    Poništi
  10. proslijedio/la je Tweet
    18. sij

    Another bump. Need some help here. If it's not obvious, this is a paying gig and involves and .

    Poništi
  11. 15. sij

    Excel decided to remove all the print areas and margin/header settings on a big workbook that generates a PDF report. Guess I don't get to write any SQL today.

    Poništi
  12. 14. sij

    Loading with starts in just under 30 minutes! Register now to join in on the fun!

    Poništi
  13. 10. sij
    Prikaži ovu nit
    Poništi
  14. 10. sij
    Prikaži ovu nit
    Poništi
  15. proslijedio/la je Tweet
    9. sij

    The number of times I type "git" instead of "get" in casual conversation is way too high 🤦‍♀️

    Poništi
  16. 6. sij

    The catch with v12: estimates on the array data are way off on the mostly-sparse values. No issues before b/c parallel didn't work with PostGIS stuff and JIT was disabled by default. Disabling both retains roughly Pg11 performance

    Prikaži ovu nit
    Poništi
  17. 6. sij

    Updated guide to load to using osm2pgsql & latest versions... osm2pgsql v1+ changed switches from prior versions (no more --unlogged) Pg12 parallel query now works with PostGIS, I'm seeing 15-20% faster full loads over Pg11!

    Prikaži ovu nit
    Poništi
  18. proslijedio/la je Tweet
    3. sij

    The new postgres extension "pg_transport" looks interesting (see ) but as my friend Simon Riggs would say... "Where is the code? What is the license? When will it be contributed back to the community?"

    Poništi
  19. proslijedio/la je Tweet
    20. pro 2019.

    😍 xmas beer - a SysIPA - homebrewed by my colleague 🎄😋

    Poništi
  20. proslijedio/la je Tweet
    19. pro 2019.
    Poništi

Čini se da učitavanje traje već neko vrijeme.

Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.

    Možda bi vam se svidjelo i ovo:

    ·