DHH discusses SQLite (and Stoicism)

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

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

  • @Xe054
    @Xe054 5 месяцев назад +124

    Woah, it's shocking how much Twitter can skew reality. People love to hate on DHH there, but I found this entire conversation so damn inspirational! Thank you both for sharing your insights. I'm super grateful and gained a new perspective on what it means to be a developer.

    • @Half-code
      @Half-code 5 месяцев назад

      Lame idiots hate on DHH

    • @aberbaCodes
      @aberbaCodes 5 месяцев назад +4

      Twitter sheep

    • @arbitrarysequence
      @arbitrarysequence 5 месяцев назад +6

      It's shocking that people are shocked to find social media of most any kind can skew their reality.
      No offense intended, I'm happy for you.

    • @Qwonk
      @Qwonk 5 месяцев назад +4

      People on twitter are dumb though 😂 most devs love building complex monstrosities instead of solving business problems. That’s why they work for a company and PMs

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

      Have never seen hate towards him on Twitter, only praise

  • @DS-ow2ge
    @DS-ow2ge 5 месяцев назад +219

    DHH is one of those people who starts with these takes that seem super out there and then society just converges on them over time. I bet he bough nvidia stock a decade ago

    • @KushLemon
      @KushLemon 5 месяцев назад +13

      🤡

    • @leularia
      @leularia 5 месяцев назад +8

      🤡

    • @RR-et6zp
      @RR-et6zp Месяц назад

      lmao

    • @LaurentBourgault-Roy
      @LaurentBourgault-Roy Месяц назад +3

      I remember when he spoke against TDD and the whole internet was in an uproar... and now nobody insist that I must absolutely write a failing test first.

    • @geoblk3000
      @geoblk3000 Месяц назад +2

      @@LaurentBourgault-Roy DHH has had his fair share of controversies, but the guy codes real-world applications with real-world features and real deadlines, and that's the key. Some stuff work in theory and some work in production. Pure "theoretical" TDD doesn't work in production.

  • @dmccallie
    @dmccallie 5 месяцев назад +100

    I love the idea that one person should be able to build, deploy, and support a complete web site.

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

      We used to do it and still do. Especially rails folk.

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

      Yeah, I love doing that every day.

  • @idearat0
    @idearat0 5 месяцев назад +65

    "We cannot give up on the internet being something that individual developers can build for and be competitive on." - DHH
    Such a powerful point and one that resonates so much having watched 'www' go from a curiosity on my NeXT box to what we all use today.

  • @mattg-q3z
    @mattg-q3z 17 дней назад +2

    Aaron, I'm coming straight from your exceptional High Performance SQLite course, and this interview was just the icing on the cake. My own personal (dev) philosophies seem to be very well aligned with DHH. And I'm constantly getting shit and pushback from other devs for not wanting to put a static three page portfolio site with 12 visits/day on an AWS cluster, or for not using a massive frontend framework with a build system that's breaking every 6 months because of deprecated dependencies with criticial security vulnerabilities. "That's how we do things now", they're telling me, and hey, anyway we can charge the client for needing to update this three page portfolio site with 12 visits/day every few months, it's cool. THIS has been so refreshing and good for my soul.

  • @davidpaez_co
    @davidpaez_co 5 месяцев назад +27

    DHH is slowly becoming my virtual mentor. That bit about stoicism was great. Amazing interview, thank you Aaron!

  • @marlonmarcello
    @marlonmarcello 5 месяцев назад +35

    Great interview Aaron, thank you! You are a great communicator, seriously. Interesting questions, you never intererrupt and you are legit interested. Keep up the great work and I am looking forwards to that SQLite course!

    • @aarondfrancis
      @aarondfrancis  5 месяцев назад +3

      Thank you so much! I really appreciate that. I had a lot of fun talking to him

  • @RajeshM-hy1qm
    @RajeshM-hy1qm Месяц назад +2

    I owe a lot to Rails. It got me started on my journey as a self-taught software developer. Grateful for the work DHH has done and continues to do and make it available to the rest of us.

  • @theSlavenIvanov
    @theSlavenIvanov 5 месяцев назад +21

    Love how exited DHH gets whenever he talks about tech!

  • @theshinyplayer2373
    @theshinyplayer2373 5 месяцев назад +18

    Great content Aaron and David, thanks! I really agree with David on complexity. I've been a one man team since my teens, and I've learnt quite a few times that complexity(and dependencies) are both a huge risk. Less complexity and dependencies makes it so much easier to come back to something you wrote 10 years ago that is now in need of a small update.

  • @Leonhart_93
    @Leonhart_93 5 месяцев назад +28

    Aaron, you have the perfect attitude towards things to make new people be interested in an older language like PHP, Laravel and all the stuff around that.
    Your combination of general lightness and genuine interest in these things works really well. You are probably making a significant difference in changing some of the negative reputation of the language, keep it up!

    • @ivan.jeremic
      @ivan.jeremic 5 месяцев назад +2

      I think the language should be rebranded in laravel, maybe merge the companies. Would be a smart move to take the name of the most popular php framework for the language itself

    • @aarondfrancis
      @aarondfrancis  5 месяцев назад +5

      Geeze this made my day. Thank you

    • @boenrobot
      @boenrobot 5 месяцев назад

      ​@ivan.jeremic Merging a framework and language branding is a bad idea from a historical standpoint. Once upon a time, Zend was heavily featured all over the place. The PHP core is still referred to as the Zend Engine, there's the zend_extension ini directive, and the Zend Framework... existed until recently... it's now renamed to Laminas. It started to become less popular over time as other frameworks like Symfony and Laravel started to become more popular.

  • @bongabonga3190
    @bongabonga3190 5 месяцев назад +98

    Joe: "Oh so you run a blog, whats with the 20 guys behind you?"
    Bob: "DevOps team"

    • @aarondfrancis
      @aarondfrancis  5 месяцев назад +8

      I don't get it

    • @bongabonga3190
      @bongabonga3190 5 месяцев назад +46

      ​@@aarondfrancispretty much agree with DHHs stance on needless complexity ... PPL sometimes don't even know what kind of product/application they wanna build, but set up a k8s cluster from the get go 😂

    • @illegalsmirf
      @illegalsmirf 5 месяцев назад +5

      devops IS complexity for the sake of complexity (and keeping people in jobs)

    • @electrolyteorb
      @electrolyteorb 5 месяцев назад +16

      Don't forget to setup AWS Cognito for 7-Factor authentication for all of your 4 users

    • @sandworm9528
      @sandworm9528 5 месяцев назад +4

      ​@@aarondfrancishow did you not get that 😂

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

    While negative visualization is attributed to stoicism, DHH is not the first guy I would think of to describe stoicism! Great talk.

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

    Wow, It is so good to hear the Single Person Framework philosophy. I learned JS long time ago, I even did some web dev back in early 2000 (as a backend dev, so maybe I was fullstack developer before the term was even trending). Then at some point, web dev became so complex, magic tools for css, packing js, fighting with disappearing dependencies. 100 different frameworks.
    So I never bothered to setup web dev environment. It was too much work for me to learn and configure everything for a simple fix. So I always pushed such tasks to Frontend Developers.
    But with simple tools and frameworks setup like DHH explains it at about minute 25:00 I would be again a happy fullstack developer.

  • @mkwpaul
    @mkwpaul 5 месяцев назад +16

    Hearing DHH's takes and views on thing is always a delight.

  • @SimoneFolador
    @SimoneFolador 5 месяцев назад +7

    Wonderful interview! I absolutely love how DHH is passionate about stuff, such a unique character. Thanks

    • @prevailrob
      @prevailrob 5 месяцев назад

      DHH's transition into Gilbert Gottfried is almost complete

  • @nimmneun
    @nimmneun 5 месяцев назад +8

    First? 🎉
    On a serious note ... markdown for blog/article type projects and sqlite for more complex use-cases where u need relational data ... love the simplicity 😊

  • @impromp02
    @impromp02 5 месяцев назад +2

    I've kinda known of DHH since a long time but now for the first time watching him speak. he has a very passionate and charming personality. Aaron is great host ofc.

  • @mikulcek
    @mikulcek 5 месяцев назад +4

    I am a regulare DHH blog reader, seing you two in the same place just made a lot of sense. A lot of practical value here, great talk DHH!

  • @the_schreiber
    @the_schreiber 5 месяцев назад +21

    sqlite can also be used a in-memory open-source replacement for redis using the following command:
    sqlite3 /dev/shm/database.db
    😄

    • @thegrumpydeveloper
      @thegrumpydeveloper 5 месяцев назад +2

      This is cool, but I think my surprising takeaway was that ssd and local without network can compete with redis on another server. Only shared cached data would need an external cache

    • @onsearchfocus
      @onsearchfocus 3 месяца назад

      #TIL

  • @jamieknight326
    @jamieknight326 5 месяцев назад +2

    SQLite is amazing. We use it within our container for holding a couple of large mostly static datasets… when running at full speed it’s handling millions of read and writes per minute.

  • @CreatorX64
    @CreatorX64 5 месяцев назад +1

    Love when a conversation like this gives me dozens of new ideas & things to try out. This interview is such a breath of fresh air when compared to the engagement-oriented needless drama that goes on in Twitter. Thank you both!

  • @neverything
    @neverything 5 месяцев назад +12

    What a wonderful interview Aaron! Thanks a lot 🎉

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

    DHH rants are fun as hell to listen to.

  • @JohanEliasson
    @JohanEliasson 5 месяцев назад +4

    Love this interview and DHH has the exact right mind set. Fighting complexity ❤ Looking forward to the SQLite course!

  • @johnnyjohnsonxx
    @johnnyjohnsonxx 3 месяца назад +1

    I've been dabbling in various areas of web development since I was 12, and only 4 years ago I discovered Laravel (and through it I re-discovered PHP) and now I'm at a point where DHH described as "one developer shop".
    I can build a whole webapp that can compete against conglomerates, all by myself. And Laravel has a huge part in that. Not only because it makes coding easier with its abstractions and helper functions and stuff, because it makes you "capable" almost instantly.
    When you see that you can build a note taking app with full CRUD operations and authentication in less than an hour, then the question becomes "Okay, now WHAT do I build?". From "HOW do I build it?".
    In my opinion Laravel is the perfect example of a framework. It makes web development (and PHP) so much easier and actually FUN.

  • @wusswuzz5818
    @wusswuzz5818 5 месяцев назад +1

    Fantastic interview. Can feel the passion. Wish everyone could have the opportunity to do a work stint with persons like this.

  • @ivanradunovic5984
    @ivanradunovic5984 5 месяцев назад +1

    What an inspiration. I was not aware that this approach has a name Negative Visualization, but that's what I am doing all the time.

  • @justine_chang39
    @justine_chang39 5 месяцев назад +1

    although I'm a Typescript fanboy, I cannot deny that this podcast was very nice to watch. This guys is so interesting.

  • @catsby9051
    @catsby9051 Месяц назад +4

    It's interesting to see someone like DHH and then someone like Jonathan Blow who, generally speaking, tend to be on opposite ends of programming culture both saying that modern web technology has become a convoluted mess.

  • @Aeric80
    @Aeric80 3 месяца назад +1

    I use SQLite in production where I build a support ticketing system as a single developer. I don't use any modern JS framework or TS. Just plain jquery, html, bootstrap. I also build my own Web Api framework and ORM that can connect to MySQL, MSSQL, Firebird and PostgreSQL. The backend is written in B4X that compiles into java application.

  • @hanes2
    @hanes2 5 месяцев назад +3

    Pocketbase been awesome for me, which is SQLite

  • @robrobob
    @robrobob 5 месяцев назад

    What a great conversation! Such good vibes and so much positivity. It's amazing what you can do with tools nowadays that 10 or 20 years ago would have been considered crazy. His comments around reducing complexity resonated with me so much.
    After 2 years of JS/Typescript/Feathers/React dev and getting back to PHP now, I'm having so much fun again! I've taken an ultra minimalist approach with my current PHP project and I'm getting so much done! SQLite is such an interesting option because there's so few moving parts. In the interest of simplicity and getting things done, it's looking like a really good option.
    I also love what he said about customers not caring about the underlying tech. As long you're adding value and customers are having a great experience, it's going to make zero difference to them what you use underneath.
    Anyway, thanks so much for sharing another great video!

  • @AtaideCarlos
    @AtaideCarlos 5 месяцев назад +2

    31:02 "PHP" 😁 Bring it back! Ah, the nostalgia...

  • @StephenFosterUK
    @StephenFosterUK 5 месяцев назад +1

    So that was a joy. I'm also realising that some other "influencers" have influenced my perception of DHH.

  • @YT_Watcher
    @YT_Watcher 5 месяцев назад +4

    35:00
    This should be the mindset of anyone not only programmers.
    You shoud be capable of doing anything alone.
    Gain enough knowledge.

  • @asdqwe4427
    @asdqwe4427 4 месяца назад

    Having been fighting Kubernetes every 6 months for the past 3 years, I'm starting to love this podcast ❤

  • @salvatoreshiggerino6810
    @salvatoreshiggerino6810 4 месяца назад

    The "view source" thing was my favorite thing about HyperCard. We really need to bring that back.

  • @panggilmeiam
    @panggilmeiam 5 месяцев назад +1

    LibSQL is for another case, and now they have native extension for PHP and also for Driver for Laravel!

  • @Kane0123
    @Kane0123 5 месяцев назад

    Hell yeah! What a fantastic get Aaron. What a great confirmation that you’re doing great stuff.

  • @senpos
    @senpos 5 месяцев назад +5

    Watched it on your site and dhh was on the right side of the screen! Technology!

    • @aarondfrancis
      @aarondfrancis  5 месяцев назад +6

      What will they think of next??

  • @jonnyso1
    @jonnyso1 Месяц назад +2

    My only real problem with Sqlite is how much of a pain it is to make changes to the tables, if you need to change your schema, especially when using indexes and foreign keys, it works but its a hassle.

  • @jungervin8765
    @jungervin8765 4 месяца назад

    So true. Most developers can't appreciate it, because they uneducated, they only can see the downsides of javascript and the complexity of the WEB, but they don't understand the problems that this tech solving and all the opportunities.

  • @Bukosaure
    @Bukosaure 5 месяцев назад

    What a wonderful interview, really. Hard to beat this genuine content.

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

    17:38 - Yes! Thank you

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

    Great interview!!
    And I learned that SQLite has STRICT tables

  • @NeoMekhar
    @NeoMekhar 5 месяцев назад

    Hey Aaron, awsome interview. I really enjoyed it and i personally like DHH a lot. The dude's got what a lot of devs are missing IMO: a bit of common sense, heh.
    Keep up the good work, you are an inspiration!!
    Cheers!!

  • @Cyber_Lanka
    @Cyber_Lanka 5 месяцев назад

    Aaron is the best. He needs more exposure and subscribers

  • @SamadAhmed-dm3hz
    @SamadAhmed-dm3hz 5 месяцев назад

    Everything he says is common sense. I have no idea why he gets hate. So glad I found out about the Rails community and this amazing methodology towards development and business

    • @kahnfatman
      @kahnfatman 5 месяцев назад

      Twitter bubble world. Don't trust Twitter

  • @pindab0ter
    @pindab0ter 5 месяцев назад +2

    One piece of feedback: I would've loved an introduction of the guest and what they are known for. I don't know who he is or what he has done. He frequently refers to projects/companies that haven't been introduced to the listener, which was honestly a little frustrating. Practically this means that I don't know what perspective to put those statements in.

    • @EightNineOne
      @EightNineOne 5 месяцев назад +2

      He's the guy who invented Ruby on Rails and basecamp

    • @pindab0ter
      @pindab0ter 5 месяцев назад

      @@EightNineOne oh nice! See, I would’ve loved to have known that up front!

  • @St0rMsk
    @St0rMsk 5 месяцев назад +10

    Main takeaway from this video
    "Linux, it just works" - DHH

  • @alveek
    @alveek 5 месяцев назад

    DHH is a great guy
    Thanks for the interview!

  •  5 месяцев назад

    You would have explained all of that in 50 secs and make it fun. Thank you for your great content, is really inspiring.

  • @bitclaw
    @bitclaw 4 месяца назад

    Rails is awesome, really helped push web dev forward

  • @jasonpmcneill
    @jasonpmcneill 5 месяцев назад

    Key moment - 17:48
    DHH makes a powerful point: big tech companies and their architecture cannot become a dependency of individual Web developers.

  • @HenriqueGraca
    @HenriqueGraca 5 месяцев назад +1

    Amazing discussion and so many great insights !

  • @TypeScriptTV
    @TypeScriptTV 5 месяцев назад +2

    Which awesome Sony camera is DHH using? 📸

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

      Same question. I’m trying to find out, but no luck so far.

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

    “i did a thing, a thing happened” - quote of the century

  • @edhahaz
    @edhahaz 5 месяцев назад +1

    I don't see how postgres would be worse deployed locally but I could see how the massively vaster features would be better.

  • @samifouad
    @samifouad 5 месяцев назад +2

    always bet on simplicity 🔥

  • @DigitalDesignET
    @DigitalDesignET 5 месяцев назад

    Very good interview, thanks from Ethiopia.

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

    How cool would it be to have the simplicity of SQLite with the rich feature set of Postgres (JSONb support, lateral joins...)

  • @laughingvampire7555
    @laughingvampire7555 3 месяца назад

    I agree with the dependency hell, sadly I've seen it in Rails a lot with elasticsearch and qt and mysql.

  • @zx-sy1qh
    @zx-sy1qh 3 месяца назад

    "Best.... Interview.... Ever...." - Simpson's Guy

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

    SQLite is probably the most battle tested piece of software in existence.

  • @EmperorAlles
    @EmperorAlles 5 месяцев назад

    wow, can't believe this interview is happening.

  • @paulsalele3844
    @paulsalele3844 5 месяцев назад

    This was a great interview!! Thanks!! Love DHH but still disagree with him on typescript LOL

  • @Spongeoel
    @Spongeoel 5 месяцев назад

    Great conversation, loved to hear it

  • @SteveHazel
    @SteveHazel 5 месяцев назад

    the amount of a fan i am of dhh almost makes me feel ashamed. but, eh, i'm ok with that. i'm currently rewriting a huge lab test and order entry system that's half rails half php. with one other guy. and it's going well. and it's actually fun :)

  • @k98killer
    @k98killer 5 месяцев назад

    Theo demonstrated the performance issues with Hey, including substantial lags (using gigabit fiber) and a lack of debounce. It would be interesting to see him defend or at least reflect on the engineering choices that led to that flawed UX. DHH has seemed pretty dogmatic about not using reactive clients on Xitter (formerly known as Tw), so I wonder if he would even acknowledge the UX issues with Hey.

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

      They already fixed it. None of their customers noticed so it wasn't a priority

    • @k98killer
      @k98killer 5 месяцев назад

      @@aarondfrancis I see.

  • @foobars3816
    @foobars3816 5 месяцев назад

    All these people realizing that what they have been told about DHH is not the reality and he actually just cares about simplicity. I wonder how many of them still believe what they heard about Ruby.

  • @kasmanialisaad
    @kasmanialisaad 5 месяцев назад +1

    Love SQLite. Great talk

  • @daniel_petrica
    @daniel_petrica 5 месяцев назад +1

    Loved this interview

  • @igorcastilhos
    @igorcastilhos 5 месяцев назад

    Nice interview with Cbum 😂❤

  • @Whateverworksism
    @Whateverworksism 5 месяцев назад

    Love this! Great conversation.

  • @ps-dn7ce
    @ps-dn7ce Месяц назад

    This is brilliant

  • @danieljonguitud9632
    @danieljonguitud9632 4 месяца назад

    Great content, thx for sharing!

  • @popetgirl
    @popetgirl 5 месяцев назад

    Really nice podcast. I love sqlite really want to see laravel use sqlite as queue driver. I have used sqlite as queue driver as separate database just queue jobs with laravel 7 but the issue i faced it lock sqlite file if number of jobs are high same thing happen with when used mysql as queue driver jobs table was locked and don't know how to unlock that table. Loved to see sqlite as cache

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

    DHH is good at hiding flaws as Aaron is good at hiding yawns

  • @wagnerfernandes8780
    @wagnerfernandes8780 5 месяцев назад +1

    What a awesome talk!

  • @davidsiewert8649
    @davidsiewert8649 5 месяцев назад +2

    That Sony Camera with Linux support is this? Asking for a friend

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

      Same question. I’m trying to find out, but no luck so far.

  • @djordje1999
    @djordje1999 5 месяцев назад

    i need this on apple podcasts

  •  5 месяцев назад

    That was a great interview!

  • @MonsterSmart
    @MonsterSmart 4 месяца назад

    Awesome. I like the guy. There so much garbage if it comes to teaching preaching in the IT. This guy knows the value of "keep it simple"

  • @NatnaelBirhanu-ri7vb
    @NatnaelBirhanu-ri7vb 5 месяцев назад

    Great interview, Aron

  • @kisanpakhreen
    @kisanpakhreen 5 месяцев назад +2

    DHH gives me Keanu Reeves vibes of tech😂

    • @nachobek
      @nachobek 5 месяцев назад

      Haha true, for me it was Russell Brand vibes 😂

  • @jim.....
    @jim..... Месяц назад

    Inspiring!

  • @laughingvampire7555
    @laughingvampire7555 3 месяца назад

    come on, that one dude from Redis had to take a break, I mean, we are not ghosts, we need food.

  • @antondrevetskyi9526
    @antondrevetskyi9526 5 месяцев назад

    Thanks for the video!

  • @user-hk3ej4hk7m
    @user-hk3ej4hk7m 5 месяцев назад +1

    This guy is like if George Hotz and Jonathan Blow had a baby

  • @sheldon98c
    @sheldon98c 5 месяцев назад

    Great interview

  • @feelingfun5149
    @feelingfun5149 5 месяцев назад +1

    Wow! That's cool!🤘

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

    What a great dude

  • @nexovec
    @nexovec 5 месяцев назад +2

    There's an incorrect assumption that SQLite can't horizontally scale. Go see Turso or RQLite!

    • @frenchmarty7446
      @frenchmarty7446 5 месяцев назад

      RQlite doesn't scale writes, in fact writes are actually slower compared to a single SQLite instance (with the same settings). Reads only scale if you can tollerate weaker consistency levels.
      Turso is a managed service. They are almost certainly sharding and replicating data with their own proprietary layer on top of SQLite. There's nothing inherently wrong with that, but you're now talking about a separate paid service that happens to use SQLite.
      Side note: SQLite was the backend for FoundationDB for a very long time.

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

      @@frenchmarty7446 I did actually know about those restrictions but somehow conveniently forgot to mention them. But either way making it scalable would by itself just invalidate the promise of embedding the database in the program.

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

      @@frenchmarty7446 There also seems to be a video about LiteFS by Aaron that is related.

  • @daltonyon
    @daltonyon 5 месяцев назад

    Great talk!

  • @thegrumpydeveloper
    @thegrumpydeveloper 5 месяцев назад

    Wait what are the better sqlite defaults? Need these settings. Anyone read through the rails docs/source to get these better ones?

  • @PerpetualEducation
    @PerpetualEducation 5 месяцев назад

    Sneaks off to get Campfire...

  • @laughingvampire7555
    @laughingvampire7555 3 месяца назад

    next move will be distributing rails with it's own unikernel

  • @chad_giga6934
    @chad_giga6934 5 месяцев назад

    DHH MENTIONED

  • @theSlavenIvanov
    @theSlavenIvanov 5 месяцев назад

    Hi Aaron, if you run Sqlite in prod, how do you inspect the db?

    • @lilyoshi1310
      @lilyoshi1310 5 месяцев назад +1

      Copy the file local kek

    • @theSlavenIvanov
      @theSlavenIvanov 4 месяца назад

      @@lilyoshi1310 And if you want to do updates on the fly?