Dump links #19 – PostgeSQL

Wydanie specjalne – składające się tylko z linków dotyczących PostgreSQL.

  • https://www.cybertec-postgresql.com/en/understanding-lateral-joins-in-postgresql/
  • https://database.guide/how-to-test-for-overlapping-dates-in-postgresql/
  • https://www.pgmustard.com/blog/calculating-per-operation-times-in-postgres-explain-analyze
  • https://www.cybertec-postgresql.com/en/postgresql-limit-vs-fetch-first-rows-with-ties/
  • https://blog.rustprooflabs.com/2021/07/postgres-permission-mat-view

 

 

Dump links #18

Poniżej nowe, wakacyjne zestawienie dump links:

  • https://github.com/hgwr/bootstrap4-solarized-theme
  • https://application.security/free/owasp-top-10
  • https://blog.vnaik.com/posts/web-attacks.html
  • https://www.cybertec-postgresql.com/en/postgresql-understanding-deadlocks/
  • https://www.humaaans.com – „ludziki ikonki”
  • https://branch.climateaction.tech/issues/issue-1/hands-on-sustainable-web-design/
  • https://gist.github.com/willurd/5720255
  • https://privatebin.net
  • https://medium.com/nmc-techblog/advanced-console-log-tips-tricks-fa3762930bca
  • https://github.com/VictoriaMetrics/VictoriaMetrics
  • https://github.com/repodevs/sentry-on-heroku
  • https://github.com/allegro/turnilo
  • https://github.com/SimpleProxyProject/simple-proxy-2
  • https://weblate.org/pl/
  • https://stackshare.io/stackups/phrase-vs-weblate
  • https://www.narrator.ai/blog/using-postgresql-as-a-data-warehouse/
  • https://powietrze.gios.gov.pl/pjp/content/api API udostępniające dane dot. jakości pow
  • https://github.com/reacherhq/backend
  • https://observatory.mozilla.org/
 

Dump links #17

Nowy, wiosenny zrzut linków:

  • https://httptoolkit.tech/blog/http-wtf/
  • https://sempai.pl/blog/core-web-vitals-przygotuj-sie-na-zmiany/
  • https://getcomposer.org/doc/articles/versions.md
    "require": {
        "vendor/package": "1.3.2", // exactly 1.3.2
    
        // >, <, >=, <= | specify upper / lower bounds
        "vendor/package": ">=1.3.2", // anything above or equal to 1.3.2
        "vendor/package": "<1.3.2", // anything below 1.3.2
    
        // * | wildcard
        "vendor/package": "1.3.*", // >=1.3.0 <1.4.0
    
        // ~ | allows last digit specified to go up
        "vendor/package": "~1.3.2", // >=1.3.2 <1.4.0
        "vendor/package": "~1.3", // >=1.3.0 <2.0.0
    
        // ^ | doesn't allow breaking changes (major version fixed - following semver)
        "vendor/package": "^1.3.2", // >=1.3.2 <2.0.0
        "vendor/package": "^0.3.2", // >=0.3.2 <0.4.0 // except if major version is 0
    }
  • https://bootsnipp.com/snippets/EK8Dl
  • https://vanillaforums.com/en/
  • https://flarum.org/
  • https://baserow.io/
  • https://www.danhacks.com/software/grpc-rest-graphql.html
  • https://zoomescaper.com/
  • https://podcast.allegro.tech/sre_w_allegro/
  • https://devcave.pl/notatnik-juniora/zasady-projektowania-kodu
  • https://api-platform.com/ (https://github.com/api-platform/api-platform)
  • https://github.com/cubiclesoft/cloud-storage-server
  • https://github.com/cubiclesoft/sso-server
  • https://exifcleaner.com

 

 

Dump links #16

Szesnaste zestawienie dump links:

  • http://launchtower.langbroek.org/
  • https://www.supermonitoring.pl/blogpl/core-web-vitals/
  • https://pl.piwigo.org/
  • https://github.com/EdgedesignCZ/phpqa/tree/master/src
  • https://k8s.af/
  • https://iconduck.com/
  • https://tally.so – całkiem fajne narzędzie do ankiet 
  • https://github.com/sarven/unit-testing-tips
  • https://eyeondesign.aiga.org/dont-worry-these-gangley-armed-cartoons-are-here-to-protect-you-from-big-tech/
  • https://github.com/voron00/Nanny
  • https://github.com/Imangazaliev/DiDOM
  • https://devcave.pl/notatnik-juniora/zasady-projektowania-kodu
  • https://bulldogjob.pl/it-report/2021
 

Dump links #15

Kolejna seria linków: 
  • https://github.com/gumlet/php-image-resize
  • https://www.phplist.com/
  • https://countrycode.org/
  • https://pgstats.dev/
  • https://github.com/nikic/FastRoute
  • https://andybrewer.github.io/mvp/
  • https://dev.to/deleteman123/jwt-authentication-best-practices-3lf9
  • https://imisstheoffice.eu/
  • https://www.marinetraffic.com/blog/
  • https://gitlab.com/gitlab-com/gl-infra/db-migration/-/blob/master/.gitlab/issue_templates/patroni_failover.md
 

Dump links #14

Prezentujemy 14 wersje dump links: 

  • https://artillery.io/
  • https://www.sitespeed.io/
  • https://eeemo.net/
  • https://github.com/cstate/cstate
  • https://www.taniarascia.com/rest-api-sorting-filtering-pagination/
  • https://github.com/allegro/turnilo
  • https://www.metabase.com/
  • https://www.tawk.to
  • https://googlechrome.github.io/lighthouse/scorecalc/
  • https://fundingchoices.google.com/

extra drone links

  • https://axidro.pl/jak-prawidlowo-uzywac-akumulatory/
  • https://megadron.pl/pl/blog/dbalosc-o-baterie-jest-wazniejsza-niz-myslisz-1536853349.html
 

Dump links #13

Pierwsza powakacyjna lista dump links – odcinek #13.

  • https://diybookcovers.com/3Dmockups/#tabBody0
  • https://github.com/select2/select2/
  • https://www.metabase.com/
  • https://www.uvdesk.com/en/
  • https://github.com/tedious/Fetch
  • https://github.com/serbanghita/Mobile-Detect
  • https://underground.works/clockwork/
  • https://dev.to/prototyp/improving-website-performance-by-eliminating-render-blocking-css-and-javascript-28ei
  • https://codeseven.github.io/toastr/demo.html
  • https://www.haproxy.com/blog/bot-protection-with-haproxy/
  • https://www.loadbalancer.org/blog/simple-denial-of-service-dos-attack-mitigation-using-haproxy-2/,
  • https://picresize.com
  • kolory w prezentacji danych: https://blog.datawrapper.de/beautifulcolors/
  • https://cloud.google.com/workflows – automatyzacja zadań od google 
 

Dump links #12

Letnie zestawienie linków:

  • https://www.relicsww2.net/
  • https://severalnines.com/resources/database-management-tutorials/postgresql-load-balancing-haproxy
  • https://ngrok.com/
  • https://github.com/gut-space/satnogs/tree/master/server / https://satnogs.klub.com.pl/
  • https://github.com/phayes/geoPHP
  • chrome://inspect/ – dev „konsola” Chrome na mobile – same logi
  • https://space.stackexchange.com/
  • https://gis.stackexchange.com/
  • http://blog.nebula.us/32-ecmascript-6-top-10-nowosci-cz-10-operatory-rest-i-spread 
  • https://www.sqlstyle.guide/
  • https://www.toptal.com/developers/gitignore
 

Dump links #11

Zapraszam do kolejnego wydania dump linków:

  • https://www.zgred.pl/zgredia/jak-zrobic-audyt-seo-samemu/
  • https://www.zgred.pl/blog/linkowanie-wewnetrzne-jako-element-strategii-seo/
  • https://www.chartjs.org/samples/latest/scales/time/financial.html
  • https://apvarun.github.io/toastify-js/#
  • https://github.com/hangsbreaker/netpingphp
  • https://phpipam.net
  • https://www.phplist.org
  • https://semver.org/lang/pl/
  • https://github.com/bbecquet/Leaflet.PolylineDecorator
  • https://github.com/makinacorpus/Leaflet.TextPath
  • https://medium.com/@rakyll/things-i-wished-more-developers-knew-about-databases-2d0178464f78
  • https://www.duckdns.org/
  • https://surge.sh
  • https://airtable.com/
  • https://ifttt.com/
  • https://www.integromat.com/en/?pc=newuser
  • https://hookbin.com/
  • https://www.endpoints.dev/
 

Dump links #10

Przed nami kolejna wersja Dump Links:

  • https://scratchmymap.com
  • https://planefinder.net
  • http://www.satflare.com/track.asp?q=visual#TOP
  • https://pl.piwigo.org – katalog zdjęć
  • https://eklitzke.org/bash-$*-and-$@
  • http://axmpaperspacescalemodels.com
  • https://siecrowerowa.pl/map/
  • stacja pogodowa https://www.piws.ovh/month.html
  • Stacja pogodowa v2 https://chinczyk.ovh/blog/2018/09/03/piws-ver-2-amatorska-stacja-pogodowa/
  • skaner IP Windows https://www.advanced-ip-scanner.com/pl/
  • https://healthchecks.io
  • https://apvarun.github.io/toastify-js/
  • http://map.blitzortung.org/#5.45/51.474/16.639