Wes Bos & Scott Tolinski - Full Stack JavaScrip...

Zpravodajství

Technologické zprávy

Technika

779: Why SQLite is Taking Over with Brian Holt & Marco Bambini

Syntax - Tasty Web Development Treats

Full Stack Developers Wes Bos and Scott Tolinski dive deep into web development topics, explaining how they work and talking about their own experiences. They cover from JavaScript frameworks like React, to the latest advancements in CSS to simplifying web tooling.

Scott and CJ dive into the world of SQLite Cloud with special guests Brian Holt and Marco Bambini. They explore why SQLite is gaining traction, its unique features, and the misconceptions surrounding its use—let’s get into it! <h3 class="code-line" data-line-start="2" data-line-end="3"><a id= "Show_Notes_2"></a>Show Notes</h3> <ul> <li class="has-line-data" data-line-start="4" data-line-end="5"> <a href="#t=00:00">00:00</a> Welcome to Syntax!</li> <li class="has-line-data" data-line-start="5" data-line-end="6"> <a href="#t=01:20">01:20</a> Who is Brian Holt?</li> <li class="has-line-data" data-line-start="6" data-line-end="7"> <a href="#t=02:26">02:26</a> Who is Marco Bambini?</li> <li class="has-line-data" data-line-start="7" data-line-end="8"> <a href="#t=05:12">05:12</a> Why are people starting to talk so much about SQLite now?</li> <li class="has-line-data" data-line-start="8" data-line-end="9"> <a href="#t=08:47">08:47</a> What makes SQLite special or interesting?</li> <li class="has-line-data" data-line-start="9" data-line-end="10"> <a href="#t=09:46">09:46</a> What is a big misconception about SQLite?</li> <li class="has-line-data" data-line-start="10" data-line-end="11"> <a href="#t=11:13">11:13</a> Installed by default in operating systems.</li> <li class="has-line-data" data-line-start="11" data-line-end="12"> <a href="#t=12:03">12:03</a> A perception that SQLite is intended for single users.</li> <li class="has-line-data" data-line-start="12" data-line-end="13"> <a href="#t=13:36">13:36</a> Convincing developers it’s a full-featured solution.</li> <li class="has-line-data" data-line-start="13" data-line-end="14"> <a href="#t=15:11">15:11</a> What does SQLite do better than <a href="https://www.postgresql.org/">Postgres</a> or <a href="https://www.mysql.com/">MySQL</a>?</li> <li class="has-line-data" data-line-start="14" data-line-end="15"> <a href="#t=17:30">17:30</a> SQLite Cloud & local first features.</li> <li class="has-line-data" data-line-start="15" data-line-end="16"> <a href="#t=20:38">20:38</a> Where does SQLite store the offline information?</li> <li class="has-line-data" data-line-start="16" data-line-end="17"> <a href="#t=23:08">23:08</a> Are you typically reaching for ORMs?</li> <li class="has-line-data" data-line-start="17" data-line-end="18"> <a href="#t=25:00">25:00</a> What is <a href= "https://sqlitecloud.io/">SQLite Cloud</a>?</li> <li class="has-line-data" data-line-start="18" data-line-end="19"> <a href="#t=27:29">27:29</a> What makes for an approachable software?</li> <li class="has-line-data" data-line-start="19" data-line-end="20"> <a href="#t=29:18">29:18</a> What make SQLite cloud different from other hosted SQLite options?</li> <li class="has-line-data" data-line-start="20" data-line-end="21"> <a href="#t=32:13">32:13</a> Is SQLite still evolving?</li> <li class="has-line-data" data-line-start="21" data-line-end="22"> <a href="#t=34:40">34:40</a> What about branching?</li> <li class="has-line-data" data-line-start="22" data-line-end="23"> <a href="#t=37:37">37:37</a> What is the GA timeline?</li> <li class="has-line-data" data-line-start="23" data-line-end="24"> <a href="#t=40:04">40:04</a> How does SQLite actually work?</li> <li class="has-line-data" data-line-start="24" data-line-end="25"> <a href="#t=41:19">41:19</a> Questions about security.</li> <li class="has-line-data" data-line-start="25" data-line-end="26"> <a href="#t=44:28">44:28</a> But does it scale?</li> <li class="has-line-data" data-line-start="26" data-line-end="28"> <a href="#t=45:52">45:52</a> Sick Picks + Shameless Plugs.</li> </ul> <h3 class="code-line" data-line-start="28" data-line-end="29"> <a id="Sick_Picks_28"></a>Sick Picks</h3> Brian: <a href="https://www.trainerroad.com/">Trainer Road</a> Marco: Tennis <h3 class="code-line" data-line-start="33" data-line-end="34"> <a id="Shameless_Plugs_33"></a>Shameless Plugs</h3> <ul> <li class="has-line-data" data-line-start="35" data-line-end="37"> Brian: <a href="https://sqlitecloud.io/">SQLite Cloud</a>, <a href= "https://frontendmasters.com/courses/complete-intro-containers/">Frontend Masters - Containers</a>.</li> </ul> <h3 class="code-line" data-line-start="37" data-line-end="38"> <a id="Hit_us_up_on_Socials_37"></a>Hit us up on Socials!</h3> Syntax: <a href="https://twitter.com/syntaxfm">X</a> <a href= "https://www.instagram.com/syntax_fm/">Instagram</a> <a href= "https://www.tiktok.com/@syntaxfm">Tiktok</a> <a href= "https://www.linkedin.com/company/96077407/admin/feed/posts/">LinkedIn</a> <a href="https://www.threads.net/@syntax_fm">Threads</a> Wes: <a href="https://twitter.com/wesbos">X</a> <a href= "https://www.instagram.com/wesbos/">Instagram</a> <a href= "https://www.tiktok.com/@wesbos">Tiktok</a> <a href= "https://www.linkedin.com/in/wesbos/">LinkedIn</a> <a href= "https://www.threads.net/@wesbos">Threads</a> Scott:<a href="https://twitter.com/stolinski">X</a> <a href= "https://www.instagram.com/stolinski/">Instagram</a> <a href= "https://www.tiktok.com/@stolinski">Tiktok</a> <a href= "https://www.linkedin.com/in/stolinski/">LinkedIn</a> <a href= "https://www.threads.net/@stolinski">Threads</a> Randy: <a href="https://twitter.com/randyrektor">X</a> <a href= "https://www.instagram.com/randyrektor/">Instagram</a> <a href= "https://www.youtube.com/@randyrektor">YouTube</a> <a href= "https://www.threads.net/@randyrektor">Threads</a>

Scott and CJ dive into the world of SQLite Cloud with special guests Brian Holt and Marco Bambini. They explore why SQLite is gaining traction, its unique features, and the misconceptions surrounding its use—let’s get into it!
 Show Notes  00:00 Welcome to Syntax!
 01:20 Who is Brian Holt?
 02:26 Who is Marco Bambini?
 05:12 Why are people starting to talk so much about SQLite now?
 08:47 What makes SQLite special or interesting?
 09:46 What is a big misconception about SQLite?
 11:13 Installed by default in operating systems.
 12:03 A perception that SQLite is intended for single users.
 13:36 Convincing developers it’s a full-featured solution.
 15:11 What does SQLite do better than Postgres or MySQL?
 17:30 SQLite Cloud & local first features.
 20:38 Where does SQLite store the offline information?
 23:08 Are you typically reaching for ORMs?
 25:00 What is SQLite Cloud?
 27:29 What makes for an approachable software?
 29:18 What make SQLite cloud different from other hosted SQLite options?
 32:13 Is SQLite still evolving?
 34:40 What about branching?
 37:37 What is the GA timeline?
 40:04 How does SQLite actually work?
 41:19 Questions about security.
 44:28 But does it scale?
 45:52 Sick Picks + Shameless Plugs.
  Sick Picks Brian: Trainer Road Marco: Tennis
 Shameless Plugs  Brian: SQLite Cloud, Frontend Masters - Containers.
  Hit us up on Socials! Syntax: X Instagram Tiktok LinkedIn Threads
 Wes: X Instagram Tiktok LinkedIn Threads
 Scott:X Instagram Tiktok LinkedIn Threads
 Randy: X Instagram YouTube Threads

Aplikace Youradio Talk

779: Why SQLite is Taking Over with Brian Holt & Marco Bambini

Poslechněte si podcast