Mycelial

Пікірлер

@DaniIhzaFarrosi 5 күн бұрын

Thank you

@cincoer 8 күн бұрын

Im starting to see red bruh you better stop aksing questions the yap is crazy

@benoitd94 11 күн бұрын

hi very good tuto on my side the file /content/dataset/data.yaml is missing ? thanks

@ahmelq Ай бұрын

This is gold content. Thanks for sharing.

@m12652 Ай бұрын

Great stuff... have you tried using sqlite as a local client side store for a pwa without syncing to a server? I'm trying to get something going with Svelte 5 and sql.js (using wasm). It's getting as far as doing the imports etc. but crashes every time I try to create or open a database... all I get is an unhandled error

@m12652 Ай бұрын

Great stuff thanks...

@thedelanyo Ай бұрын

Great. If your db keeps updating frequently, creating covering index, might not be efficient? Right

@HideBuz Ай бұрын

Why are you using quoted connection strings sometimes and sometimes there are no quotes, even though the .method is still one word? What changes? I know you are trying to make it shell proof, but it seems weird that some commands run fine without quotes and other have quotes.

@mohamedhurab5045 2 ай бұрын

Thank you, Very helpful .

@arpanghoshal2579 2 ай бұрын

This was good, but a counter is a very simple example. What we have a string data type like imagine collaborative editing like in google docs initially eh the string was "apple" User A changed this string from "apple" to "orange" User B changed this string from "apple" to "mango" Now I imagine there will be two diffs like { "user-A": "orange"} and {"user-B": "mango" } How do we resolve this conflict do we just take the last updated diff?

@arpanghoshal2579 2 ай бұрын

Okay got a nice answer from chat gpt, sharing below How It Works Let's consider how an RGA CRDT might handle the example: Initial State: Each character in "apple" has a unique identifier. a1, p2, p3, l4, e5 User A's change ("orange"): Deletes all characters: a1, p2, p3, l4, e5 Inserts new characters with new identifiers: o6, r7, a8, n9, g10, e11 User B's change ("mango"): Deletes all characters: a1, p2, p3, l4, e5 Inserts new characters with new identifiers: m12, a13, n14, g15, o16 Merging Changes In CRDTs, changes from all users are merged in a way that ensures consistency: RGA Merging: When User A and User B's changes are merged, the CRDT ensures both sets of operations are applied. Depending on the strategy (e.g., causal ordering), one user's operations might be applied before or after the other. Example Resolution Let's consider a simple resolution where both operations are applied in the order they were received: Initial State: a1, p2, p3, l4, e5 Apply User A's changes: Deletes: a1, p2, p3, l4, e5 Inserts: o6, r7, a8, n9, g10, e11 Result: orange (o6, r7, a8, n9, g10, e11) Apply User B's changes: Deletes: a1, p2, p3, l4, e5 (no effect since already deleted) Inserts: m12, a13, n14, g15, o16 Result: orangemango (o6, r7, a8, n9, g10, e11, m12, a13, n14, g15, o16) Final State After merging: The final string could be a concatenation like orangemango, or based on the chosen strategy, it could interleave characters or even prefer one user's changes if there is a deterministic rule in place.

@edhahaz 2 ай бұрын

let me know when SQL works in the browser

@Danielo515 26 күн бұрын

It does already. Even postgres

@dikatok 2 ай бұрын

very well explained, thank you

@yehudamakarov 3 ай бұрын

lol this content is stellar well done

@paulcosta8297 3 ай бұрын

INDICES

@awksedgreep 3 ай бұрын

Exactly what I needed, thank you.

@VolodymyrPavlyshyn 3 ай бұрын

more on local first kzbin.info/www/bejne/j2LdlamQpK2AnM0

@VolodymyrPavlyshyn 3 ай бұрын

UCAN could give a granular auth

@HVossi92 3 ай бұрын

Great video, I appreciate the comparison at the end, because I kept wondering about the optimized postgres version. Did you use connection pooling for the three queries?

@atimney 3 ай бұрын

Great video, very well explained

@nodidog 4 ай бұрын

This is a fantastic explantation, thank you!

@cincoer 8 күн бұрын

i dont think so

@flaresaccount1754 4 ай бұрын

This is a really good video!

@baxiry. 5 ай бұрын

AWESOME!

@linz4213 5 ай бұрын

Fantastic introducing important concept, not mentioning language superiority (OTP rocks BTW)

@user-qp7pn1gy5e 5 ай бұрын

cool video 💀💀💀

@doyouwantsli9680 5 ай бұрын

Sqlite is the best

@RuneViniGarcia 5 ай бұрын

Wow, really nice. Thanks for the video!

@tsiroukismichael9606 5 ай бұрын

Hi , is it possible to do this process in a pythonic way locally , instead of using google colab?

@StartupSpells 5 ай бұрын

loved it. was gonna use litestream only but good to learn other backup techniques.

@kubre 6 ай бұрын

what a gem of channel

@lilhard 6 ай бұрын

You are so good, i'm a surfer and i'm looking for an alternative to the soloshot3 for autotracking, this approach can yield a very powerful app for Iphones or Android smartphones with good telephoto camera, the all combined with a gimbal to enable autotracking active surfers an a specific peak or area, i'm a developer too so i'll be working on this and give it for free just to piss off soloshot 😂

@kosmonautofficial296 6 ай бұрын

Great video!

@kishanbsh 6 ай бұрын

Does this MATCH do a fuzzy find ? How does the search work?

@aderintosadiq6059 6 ай бұрын

Yo!!! the subscribe button lit up when he said please subscribe

@princeardalan 6 ай бұрын

Thank you.

@Graveness4920 6 ай бұрын

Complex query are still worth it even if there is no network latency. If we don't do join they we have to write code for doing this and it would become more error prone and complex code where as a single query could have done it. Until there is some memory concern, I don't see a point why not to have complex query for sqlite.

@kishanbsh 7 ай бұрын

Why cant WAL mode support multiple writers at the same time? Also say you want to use sqlite for a server class app what configurations to sqlite do you consider as sensible defaults?

@maddelasaikarthik7563 7 ай бұрын

Adding example for each of the Local-first, Local and Client-Server categories would have been better.

@JOHNSMITH-ve3rq 7 ай бұрын

The question answer format becomes grating very quickly. You can convey the same info without. It’s very distracting once you notice!!

@linccg 7 ай бұрын

may i have date like '2024-01-01'?

@abhaypatil9210 7 ай бұрын

Awesome. Just Awesome!!

@yaseengousesamudri9390 7 ай бұрын

At 2:54, processes are *NOT* light-weight when compared to threads, instead threads are lightweight when compared to processes. Actors are generally more light-weight when compared to threads though.

@sprobertson 2 ай бұрын

I assume it was specifically about erlang/beam processes (a lot of what was said about processes only makes sense in that context)

@yaseengousesamudri9390 2 ай бұрын

@@sprobertson yeah, it makes sense then

@JOHNSMITH-ve3rq 7 ай бұрын

Btw these are some of the best SQLite education videos online!!

@JOHNSMITH-ve3rq 7 ай бұрын

This is great stuff. But I wish you told us how big this db is!!

@edger305 8 ай бұрын

Landed on this video at the right time.

@ben_jamin01 9 ай бұрын

You explain concepts very well 👍

@sekomer 9 ай бұрын

you are using second timing for comparison, but I think that's not right, first query directly goes and fetches data from disk, second query is. misleading and fast because first slow query was cached...

@branmuller 9 ай бұрын

This video is fantastic, underrated channel wow

@MrThierriOliveira 10 ай бұрын

Very high quality content. Congrats!

@cincoer 8 күн бұрын

r u sur about that?

@roman_mf 10 ай бұрын

The whole playlist is crazy good. Well done!

Ең жақсы KZbin

Пікірлер