Med-Mastodon

Ben HardillPostgreSQL permissions are driving me up the wall.GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;This only appears to apply to existing tables and needs to be run again after any new tables created.Anybody know a way to have it apply at the SCHEMA level including new tables?<a href="https://bluetoot.hardill.me.uk/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://bluetoot.hardill.me.uk/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a>

Paul Chambers🚧I want to move my <a href="https://oldfriends.live/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> database from the VPS that Mastodon is on.I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated <a href="https://oldfriends.live/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a> databases. Are there any downsides to moving my DB to that shared hosting setup? <a href="https://oldfriends.live/tags/MastoAdmin" class="mention hashtag" rel="nofollow noopener" target="_blank">#MastoAdmin</a>It's the Steller Plus plan at NameCheapEDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

arnoldmelmGäbe es nicht die Nerds, die <a href="https://mastodon.social/tags/Linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#Linux</a> testing oder Rolling Releases nutzen, so wäre die <a href="https://mastodon.social/tags/xzbackdoor" class="mention hashtag" rel="nofollow noopener" target="_blank">#xzbackdoor</a> nicht entdeckt worden.Man stelle sich einmal vor: Da sitzt Andres Freund an seinem <a href="https://mastodon.social/tags/Debian" class="mention hashtag" rel="nofollow noopener" target="_blank">#Debian</a> Sid und testet die neueste Version von <a href="https://mastodon.social/tags/xz" class="mention hashtag" rel="nofollow noopener" target="_blank">#xz</a> für sein <a href="https://mastodon.social/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a> und ärgert sich über ein 500 Millisekunden zu langsames Login via <a href="https://mastodon.social/tags/ssh" class="mention hashtag" rel="nofollow noopener" target="_blank">#ssh</a>.Wenn das nicht nerdig ist! Es war Glück, aber kann immer wieder passieren.

Michael GieslerHab da ein <a href="https://ruhr.social/tags/Jobangebot" class="mention hashtag" rel="nofollow noopener" target="_blank">#Jobangebot</a>: <a href="https://ruhr.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a>, <a href="https://ruhr.social/tags/Spryker" class="mention hashtag" rel="nofollow noopener" target="_blank">#Spryker</a>, <a href="https://ruhr.social/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a>, <a href="https://ruhr.social/tags/graphql" class="mention hashtag" rel="nofollow noopener" target="_blank">#graphql</a> in cooler Firma bei 100% <a href="https://ruhr.social/tags/homeoffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#homeoffice</a> oder wahlweise in <a href="https://ruhr.social/tags/Essen" class="mention hashtag" rel="nofollow noopener" target="_blank">#Essen</a> oder <a href="https://ruhr.social/tags/Bocholt" class="mention hashtag" rel="nofollow noopener" target="_blank">#Bocholt</a>. Dazu gibt's <a href="https://ruhr.social/tags/Scrum" class="mention hashtag" rel="nofollow noopener" target="_blank">#Scrum</a> (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima <a href="https://ruhr.social/tags/Arbeitsklima" class="mention hashtag" rel="nofollow noopener" target="_blank">#Arbeitsklima</a>.Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?<a href="https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/" rel="nofollow noopener" translate="no" target="_blank">https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/</a><a href="https://ruhr.social/tags/FediJobs" class="mention hashtag" rel="nofollow noopener" target="_blank">#FediJobs</a> <a href="https://ruhr.social/tags/FediHire" class="mention hashtag" rel="nofollow noopener" target="_blank">#FediHire</a> <a href="https://ruhr.social/tags/getFedihired" class="mention hashtag" rel="nofollow noopener" target="_blank">#getFedihired</a>

UmnikЕсть причина, по которой лучше выбрать <a href="https://lor.sh/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#mariadb</a> нежели <a href="https://lor.sh/tags/postgressql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgressql</a>?

DaoudIt turns out that a <a href="https://toot.wales/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a> table to store URLs crawled is a bad idea: the table is currently 749G on disk. In contrast, a bloom filter with a 1e-7 error for a billion items will take up about 4G <a href="https://hur.st/bloomfilter/?n=1000000000&p=1.0E-7&m=&k=" rel="nofollow noopener" translate="no" target="_blank">https://hur.st/bloomfilter/?n=1000000000&p=1.0E-7&m=&k=</a><a href="https://toot.wales/tags/mwmbl" class="mention hashtag" rel="nofollow noopener" target="_blank">#mwmbl</a> <a href="https://toot.wales/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://toot.wales/tags/searchengine" class="mention hashtag" rel="nofollow noopener" target="_blank">#searchengine</a>

💧🌏 Greg CocksNational Park Services (NPS) ‘Park Tiles’ [public web mapping, USA] -- <a href="https://www.nps.gov/maps/tools/park-tiles/index.html#12/38.5640/-107.6372" rel="nofollow noopener" target="_blank">https://www.nps.gov/maps/tools/park-tiles/index.html#12/38.5640/-107.6372</a> <-- entry point -- [also a mobile app ] “Park Tiles is a suite of online basemaps designed to fit the National Park Service’s graphic identity. Built with simplicity and flexibility in mind, Park Tiles basemaps can be used as stand-alone reference maps, or customized web maps with additional data overlays. Park Tiles features NPS-sourced data inside park boundaries, and relies on OpenStreetMap data to provide additional context…” <a href="https://techhub.social/tags/GIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#GIS</a> <a href="https://techhub.social/tags/spatial" class="mention hashtag" rel="nofollow noopener" target="_blank">#spatial</a> <a href="https://techhub.social/tags/mapping" class="mention hashtag" rel="nofollow noopener" target="_blank">#mapping</a> <a href="https://techhub.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostGIS</a> <a href="https://techhub.social/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a> <a href="https://techhub.social/tags/QGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#QGIS</a> <a href="https://techhub.social/tags/vectortiles" class="mention hashtag" rel="nofollow noopener" target="_blank">#vectortiles</a> <a href="https://techhub.social/tags/opendata" class="mention hashtag" rel="nofollow noopener" target="_blank">#opendata</a> <a href="https://techhub.social/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://techhub.social/tags/gischat" class="mention hashtag" rel="nofollow noopener" target="_blank">#gischat</a> <a href="https://techhub.social/tags/ParkTiles" class="mention hashtag" rel="nofollow noopener" target="_blank">#ParkTiles</a> <a href="https://techhub.social/tags/OSM" class="mention hashtag" rel="nofollow noopener" target="_blank">#OSM</a> <a href="https://techhub.social/tags/basemaps" class="mention hashtag" rel="nofollow noopener" target="_blank">#basemaps</a> <a href="https://techhub.social/tags/NPS" class="mention hashtag" rel="nofollow noopener" target="_blank">#NPS</a> <a href="https://techhub.social/tags/maps" class="mention hashtag" rel="nofollow noopener" target="_blank">#maps</a> <a href="https://techhub.social/tags/webmaps" class="mention hashtag" rel="nofollow noopener" target="_blank">#webmaps</a> @NPS

Elan HassonImporting the <a href="https://publicsquare.global/tags/Google" class="mention hashtag" rel="nofollow noopener" target="_blank">#Google</a> <a href="https://publicsquare.global/tags/ngram" class="mention hashtag" rel="nofollow noopener" target="_blank">#ngram</a> <a href="https://publicsquare.global/tags/Data" class="mention hashtag" rel="nofollow noopener" target="_blank">#Data</a> set into <a href="https://publicsquare.global/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a>.I'm almost done with the bi-grams.I've got about ~900GB more to import, then it's on to the tri-grams.This is an entire, unfiltered set, that I'm going to backup first and put in cold storage.Then I'm going to filter out rows that have characters that aren't allowed in <a href="https://publicsquare.global/tags/HashTags" class="mention hashtag" rel="nofollow noopener" target="_blank">#HashTags</a>. This is the dataset that will power <a href="https://publicsquare.global/tags/FediMod" class="mention hashtag" rel="nofollow noopener" target="_blank">#FediMod</a>'s hashtag <a href="https://publicsquare.global/tags/accessibility" class="mention hashtag" rel="nofollow noopener" target="_blank">#accessibility</a> service.

Kingsley Uyi Idehen<a href="https://mastodon.social/@ascherbaum" class="u-url mention" rel="nofollow noopener" target="_blank">@ascherbaum</a>,Quest: Existence of an <a href="https://mastodon.social/tags/ODBC" class="mention hashtag" rel="nofollow noopener" target="_blank">#ODBC</a> binding for Mastodon that decouples it from <a href="https://mastodon.social/tags/PostgresSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgresSQL</a>.<a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> only comes into play due to our mysql2odbc library for decoupling MySQL apps.Based on our expertise and 30+ years of experience re <a href="https://mastodon.social/tags/DataAcces" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataAcces</a>, <a href="https://mastodon.social/tags/DataConnectivity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataConnectivity</a> (ODBC and <a href="https://mastodon.social/tags/JDBC" class="mention hashtag" rel="nofollow noopener" target="_blank">#JDBC</a>), and DBMS tech (see our <a href="https://mastodon.social/tags/VirtuosoRDBMS" class="mention hashtag" rel="nofollow noopener" target="_blank">#VirtuosoRDBMS</a>), I know we can build such a binding if need be. Initially though, I am curious about what may already exist rather than what’s possible 😊/cc @el_pink@sueden.social <a href="https://mastodon.social/@Mastodon" class="u-url mention" rel="nofollow noopener" target="_blank">@Mastodon</a>

Recent searches

Search options

Administered by:

Server stats:

#postgressql