HackerTrans
TopNewTrendsCommentsPastAskShowJobs

guyromm

no profile record

Submissions

PostgreSQL, PostgREST and Svelte are a bliss to develop with

webgma.co.il
3 points·by guyromm·5 वर्ष पहले·0 comments

comments

guyromm
·9 माह पहले·discuss
here's a webgl poc that was tested with mobile & desktop browsers: https://www.webgma.co.il/Articles/window-3d-tracking/en/

source code at https://github.com/guyromm/Window

imho this should be useful for driving/flight sims, giving the player the ability to lean inside the vehicle, changing their viewpoint on the surroundings.
guyromm
·10 माह पहले·discuss
the ultimate laptop bag is an inflatable orange swimming tow float bag: 1. it looks nothing like a laptop bag 2. it will protect your laptop from water, even completely submerged. 3. it will protect your laptop from falling when side pockets are inflated. 4. you can take your laptop to the beach and not worry about it getting stolen. 5. you can use it as a pillow when hiking or at the beach. 6. much cheaper than a laptop bag.

mine's a Decathlon OWS 500, but i guess that it's as good as any.
guyromm
·4 वर्ष पहले·discuss
I believe they were working under the assumption it would be a walk in the park, once the central government was captured or killed.

To strengthen this assumption here's a canned article which was likely meant to be published had things gone according to plan, but pulled, since they hadn't.

https://web.archive.org/web/20220226224717/https://ria.ru/20...

RIA is a state owned news agency.

Why precisely they thought they'd meet no serious opposition in their attempted airdrop near Kyiv is anyone's guess. Mine is that Putin started believing his own tales about Nazis taking Ukraine hostage, assuming the populace is dying to be liberated from them.

Things crumbled once this met a different reality on the ground, and now they're trying to raise the stakes, and have become desperate enough to begin indiscriminately shelling population centres, Kharkiv most notably.
guyromm
·5 वर्ष पहले·discuss
(disclaimer: not feeling totally authoritative on this, have not used graphql in production).

i feel that the choice between postgrest & postgraphile / another graphql solution revolves around whether you're a front-end dev who doesn't get to arbitrarily change/expose data schema. if this is true, and you are collaborating with other devs on the code then the added flexibility in querying probably outweighs the inferred complexity of this complex data abstraction.

if, however, you control both back and front-end, graphql isn't really needed, as you can expose whatever views you fancy by means of SQL (via views, table/row permissions, rpc functions exposed by postgrest, etc)
guyromm
·5 वर्ष पहले·discuss
thank you! am still waiting to see if/when it'd feature on svelte fall summit before "properly" posting it.

btw. i've also done on a step-by-step "sample app" tutorial for svelte+postgrest. i'd say its still a little rough: https://www.webgma.co.il/Tech/
guyromm
·5 वर्ष पहले·discuss
postgREST is the bomb and, together with svelte, changed my life, productivity wise - no less.

here's a short video explaining how this project can allow a front-end developer unleash PostgreSQL's power without having to write backend code.

https://drive.google.com/file/d/1ncp00Mb7L3TO9TIRgNEF6pRdt-b...
guyromm
·5 वर्ष पहले·discuss
that's actually precisely what i implemented in my postgrest-svelte starter template (https://github.com/guyromm/svelte-postgrest-template).

./pg_schema_dump.sh breaks down the schema into an entity-per-file structure at ./sql/schema, while. ./db_init.sh knows how to create a fresh database schema from this dump. the per-file breakdown allows to nicely version the schema in git.
guyromm
·5 वर्ष पहले·discuss
https://www.gnu.org/fun/jokes/ed-msg.en.html
guyromm
·5 वर्ष पहले·discuss
that one i did take for a spin.

i must say that the experience is quite horrible - that torture of having to write map/reduce functions, added with some erratic behavior in regards to data integrity (inserted entries silently discarded, sync to the remote couchdb instance working somewhat whimsically). as soon as your dataset is sizable in any regard (tens of thousands of records in a collection, if i recall the terminology) it begins to just break apart.

was writing a browser extension, and used pouch with the hope of keeping its persistence local and avoid needing a server. seeing that it leaks tried to trade it for a couchdb server. seeing how bad sync is, and that couch is not very comfortable to work with either ended up throwing the thing in favor of a postgresql+postgrest backend.
guyromm
·5 वर्ष पहले·discuss
i wonder if it's possible to plug any kind of streaming replication onto this. i don't have much sqlite experience, but maybe someone here has an idea if it would be possible to run litestream or something of the sort, as both master and slave - in the browser.

that would solve the safari indexeddb 7 day ttl issue to start with.

and if replication could be made to work on top of something like webrtc we're looking at a great foundation to start building distributed, decentralized browser apps.
guyromm
·5 वर्ष पहले·discuss
(postgresql) + postgrest + svelte. expanded upon in detail here: https://webgma.co.il/Articles/rapid-prototyping-with-postgre...

performance wise, postgrest is written in haskell and is extremely snappy and stable. so your bottlenecks in essence are your data access patterns & how much you've optimized your postgresql schema for that.
guyromm
·5 वर्ष पहले·discuss
Back in 2004 or so, I was building a distributed CMS with the goal of creating artificial "link pyramids" with the purpose of SEO, which was a rather new thing at the time.

Content generation was one of our bottlenecks, and as Google was already rather successful at detecting duplicate content, we were looking for a way to "uniqify" posts that would be used to stuff sites intended for googlebot, but not humans.

One of the methods that worked was taking source English content, running it through Babelfish, the Altavista translator to French, Spanish or German, and then using the same method to translate it back to English.

This resulted in texts that did not make much sense to humans, were full of precisely such "tortured phrases" but which were considered unique by Google.
guyromm
·5 वर्ष पहले·discuss
please consider adding support for svelte!
guyromm
·5 वर्ष पहले·discuss
has anyone tested if arbitrary third party extensions (non mac store ones) are installable? and if not, how are developers expected to write & test mobile safari extensions?

i'm pretty skeptic of the prospects that apple would open up a hole in their walled garden on their own initiative. it's not like they're (currently) under any pressure or competition there.