Vectors in SQLite! (with libSQL)

Поделиться
HTML-код
  • Опубликовано: 28 дек 2024

Комментарии • 50

  • @ylynfatt
    @ylynfatt 2 месяца назад +27

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

  • @OnlinePseudonym
    @OnlinePseudonym 2 месяца назад +10

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

  • @uquantum
    @uquantum Месяц назад +1

    Fantastic, thanks for sharing! Love the code-a-long with useful AI-related use of vectors in sqLite!

  • @Reichstaubenminister
    @Reichstaubenminister 10 дней назад

    I find it incredibly funny that you still have to look up the argument order for explode. I started with PHP in 2011 and have to do the same every time I come back to it. I still love it, though.

  • @nullzeon
    @nullzeon 2 месяца назад

    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 👀)

  • @goaserer
    @goaserer 2 месяца назад +10

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

  • @notrab
    @notrab 2 месяца назад +2

    Awesome video Aaron!

  • @jimshtepa5423
    @jimshtepa5423 8 дней назад

    Aaron, thank you for amazing presentation and educational material. a quick question do you store the articles in the markdown format in the db?

  • @AhmedSalah-xm9xu
    @AhmedSalah-xm9xu 2 месяца назад +4

    I am interested in the driver aswell

  • @villainhd17
    @villainhd17 2 месяца назад

    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! 🙌

  • @curtisgmchale
    @curtisgmchale 2 месяца назад +2

    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?

  • @EinLinuus
    @EinLinuus 2 месяца назад

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

  • @stefanadams3077
    @stefanadams3077 2 месяца назад +1

    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?

  • @x7ryan
    @x7ryan 2 месяца назад

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

  • @drantunes
    @drantunes 2 месяца назад +2

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

    • @heyjorgedev
      @heyjorgedev 2 месяца назад +4

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

  • @vedovelli
    @vedovelli 2 месяца назад +1

    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!

  • @parfitt4
    @parfitt4 2 месяца назад

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

  • @RodyDavis
    @RodyDavis 2 месяца назад

    This is so awesome!

  • @RicardoVargas03
    @RicardoVargas03 Месяц назад

    Great video!

  • @Defqon1612
    @Defqon1612 2 месяца назад

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

  • @karlismillers706
    @karlismillers706 Месяц назад

    Hi! Fantastic content! I'm definitely interested in the Laravel LibSQL driver.

  • @daniel_petrica
    @daniel_petrica 2 месяца назад

    I'm interested in the Laravel driver

  • @maxicms4052
    @maxicms4052 2 месяца назад

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

  • @discoverlance
    @discoverlance 2 месяца назад

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

  • @ktwalri
    @ktwalri 2 месяца назад

    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.

  • @bobby_builds
    @bobby_builds Месяц назад

    What code editor are you using? It looks really nice and minimal

  • @mobythereal
    @mobythereal 2 месяца назад

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

  • @aryzen2781
    @aryzen2781 Месяц назад

    how would you do 1 sqlite db per user. can you do a video on that

  • @thomas2448
    @thomas2448 2 месяца назад

    Definitely interested in the Laravel driver for libSQL!

  • @AbegazNap
    @AbegazNap 2 месяца назад

    amazing video, what a lad

  • @nicobaier5424
    @nicobaier5424 2 месяца назад +1

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

    • @aarondfrancis
      @aarondfrancis  2 месяца назад +1

      Shoot, right you are! ruclips.net/video/QiocnnlcXIU/видео.html

    • @nicobaier5424
      @nicobaier5424 2 месяца назад

      @@aarondfrancis Thanks!

  • @LenWoodward
    @LenWoodward 2 месяца назад

    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.

  • @i_Amazin_
    @i_Amazin_ Месяц назад

    100% interested in a libsql driver for Laravel. The current one is… not super easy to use.
    Need to make it easily installable on prod machines as well

  • @balduin_b4334
    @balduin_b4334 2 месяца назад +1

    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
    @spicynoodle7419 2 месяца назад +1

    Yay for a Laravel driver

  • @roeyco83
    @roeyco83 Месяц назад

    very cool... can't believe the MySQL teams doesn't promote vector search when even sqlite do 🤦‍♂

  • @TheMaxiviper117
    @TheMaxiviper117 2 месяца назад

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

  • @HappyDancerInPink
    @HappyDancerInPink 2 месяца назад

    It's buggy

    • @aarondfrancis
      @aarondfrancis  2 месяца назад

      ... go on

    • @HappyDancerInPink
      @HappyDancerInPink 2 месяца назад

      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.

  • @Ruhigengeist
    @Ruhigengeist 2 месяца назад

    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
      @aarondfrancis  2 месяца назад

      Just a matter of preference. You do you

    • @Ruhigengeist
      @Ruhigengeist 2 месяца назад

      @@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
      @aarondfrancis  2 месяца назад

      @@Ruhigengeist indeed!