Vectors in SQLite! (with libSQL)

[@ylynfatt]

I'm interested in learning more about the Laravel Driver for Turso LibSQL.

[@OnlinePseudonym]

Great.... Now to learn what an embedding is!

[@x7ryan]

Yes, I've been waiting for a Turso Eloquent driver!

[@EinLinuus]

Awesome! Really interested in the driver, definitely want to try this out. Great video as always 🎉

[@nullzeon]

man these vids are so good, ever since you got me into Laravel I've been hooked on this channel (a Turso driver for Laravel sounds sooo cool, hopefully we get a vid 👀)

[@notrab]

Awesome video Aaron!

[@parfitt4]

Fantastic video. Can’t wait to try something like this.

[@villainhd17]

Awesome video! 🔥 It's amazing, I've been wanting to use Turso for my project but can't because of the missing driver 😢 Super interested in the driver you're working on! Keep up the great work! 🙌

[@vedovelli]

I am super eager to start using Turso to power my SaaS but I simply can't because the PHP extension won't work with Herd. That's a bummer. Great video, thank you!

[@AhmedSalah-xm9xu]

I am interested in the driver aswell

[@goaserer]

Wait, this AI stuff can be used for actual useful things. Nice video btw

[@stefanadams3077]

This was great! I'm interested in learning more from you about what vectors are and what that has to do with a database. In general, I think you explained your objective very well and this was a fantastic subject matter using OpenAI. I just struggled to keep up with what OpenAI was used for and what vectors are. Would you run your OpenAI query and create your indexes on every page load, or would you have a separate scheduled job to do that as needed / on a schedule?

[@ktwalri]

Very interested in a good Laravel Turso driver. The current driver doesn’t work for multiple libsql database connections. The app I’m paying Tighten to develop for me uses a mix of SQLite, Turso and MySQL databases. Turso databases use embedded replicas. Turso databases are per user while SQLite databases are local to the app instance. Laravel really needs a first class driver ready for production in real multi-tenant applications. Looking forward to trying your Turso driver for Laravel.

[@drantunes]

For a new article, you need re-generate all embeddings? Curiosity: how much did it cost to generate these embeddings?

[@heyjorgedev]

When you add a new article you can generate the embeddings for that new article. You don’t need to regenerate everything

[@Defqon1612]

Why would Eloquents' updateOrCreate not work for the upsert in SQLite?

[@mobythereal]

you should make an event listener to get the embedding when a new article is created.

[@RodyDavis]

This is so awesome!

[@thomas2448]

Definitely interested in the Laravel driver for libSQL!

[@discoverlance]

I know there's already a laravel driver for libsql even mentioned in their official docs on turso, or is it not good enough?

[@curtisgmchale]

I just tried to get the RSS feed from your site and not only is the content old, it isn't even all your content. Is there an RSS feed available that gives me everything?

[@maxicms4052]

Thanks very interested in Turso and your new libsql laravel driver.

[@LenWoodward]

Very interested in the Laravel driver. Shipping some new things soon, and we're already on sqlite, but we want all these libsql benefits in a managed way.

[@AbegazNap]

amazing video, what a lad

[@nicobaier5424]

You mention a link to a video about the sqlite backend for your website - don't see it in the description!

[@aarondfrancis]

Shoot, right you are! kzbin.info/www/bejne/h5rSlKGkociLf7c

[@nicobaier5424]

@@aarondfrancis Thanks!

[@daniel_petrica]

I'm interested in the Laravel driver

[@balduin_b4334]

How necessary do you think is recalculating the embedding on blog edits? Unless the user is an idiot (last time I checked they mostly are) they wouldn't rewrite an entire different article in an existing one. -- Maybe only do it when the title changes or something

[@spicynoodle7419]

Yay for a Laravel driver

[@TheMaxiviper117]

The text embeddings have a real utility other than being used for AI, a lot of applications.

[@Ruhigengeist]

It kinda bothers me that you align your Heredocs at the left gutter, you don't need to do that! Since PHP 7.3, you can indent your heredocs, and as long as the closing marker matches the indentation of all the content, it will strip that much indentation from each line of content. It's muuuch nicer!

[@aarondfrancis]

Just a matter of preference. You do you

[@Ruhigengeist]

@@aarondfrancis 😲 you actually prefer it on the left gutter? Why? I find that surprising, everyone I've mentioned this to just didn't realize it was possible

[@aarondfrancis]

@@Ruhigengeist indeed!

[@HappyDancerInPink]

It's buggy

[@aarondfrancis]

... go on

[@HappyDancerInPink]

I encountered a sorting error with a pretty simple libsql query that was unhandled. It was in production for a startup so I didn't have time to dig into it, just had to migrate to sqlite again. I get that it's open source, and I should open a PR yada yada... But Turso make money off this thing and purposely make documentation for using libsql opaque so you'll use their paid service. The stability of sqlite is a selling point yet my experience is it's not ready for production.