Piotr Sarna @sarna_dev Twitter profile

Last Seen Profiles

@cinna_spice_pup

@galery_basah10

@clemkohlanta

@SPInstitute_MS

@NWalkbar

@JoshRojass

@So6Dali

@Trasirc_2018

@younqri

@tmhs_post

@JaffBayar

@zhu_doc

@NNN_5468

@jorgeehg92

@MarkAlfafara004

@bethlittleford

@BrainBigTrades_

@sakurako_cos7

@DianeSawyer

@deaver50860

@WeAllMatter11

@CarlosD55941404

@semillamexico

@iamumutgezer

@AmyIreson

@PalEmbassyZa

@KB_GetBuckets14

@nicoaleluv

@mTaRig13

@ZoOnDuRy

@BinfareaS79691

@ccliong98

@m_stevenson78

@Abef7ll3

@asuka_heppoko

@ny_xilk

Piotr Sarna

@sarna_dev

9 months

SQLite takes multitenancy to the next level. Just tested @tursodatabase 's libsql-server hosting 100k databases, querying them all in a loop. It used 1.6GiB of RAM. I could host a database for everyone in my town on a Raspberry Pi (and still have spare memory for @The_Pi_Hole ).

4

55

375

Piotr Sarna

@sarna_dev

1 year

It's out! And it's free! Database Performance at Scale, everyone:

Database Performance at Scale

link.springer.com

Piotr Sarna

@sarna_dev

1 year

Attention everyone, we wrote a book on databases! Along with amazing @c_a_dunlop , @cardeneti82118 , and Pavel, my ex-colleagues from @ScyllaDB . I *really* enjoyed writing the Drivers chapter. It's going to be freely available in ebook form once released as an @Apress Open book,

7

49

210

4

59

245

Piotr Sarna

@sarna_dev

1 year

Attention everyone, we wrote a book on databases! Along with amazing @c_a_dunlop , @cardeneti82118 , and Pavel, my ex-colleagues from @ScyllaDB . I *really* enjoyed writing the Drivers chapter. It's going to be freely available in ebook form once released as an @Apress Open book,

7

49

210

Piotr Sarna

@sarna_dev

1 year

Author copies just arrived, yay! Also, e-book of Database Performance at Scale is free forever, grab one at

4

34

199

Piotr Sarna

@sarna_dev

10 months

Browser -- do you mean database server? libSQL in WAL mode compiles to #Wasm now. Lots of amazing stuff coming soon #SQLite

3

7

54

Piotr Sarna

@sarna_dev

1 year

Wondering just how ergonomic @ziglang is? I've never touched either @PostgreSQL source code or Zig in my life, and yet I was able to cook a working, loadable Postgres extension in Zig in a few hours today. Amazing interoperability with C! Details coming soon 😎

1

7

53

Piotr Sarna

@sarna_dev

11 months

If you're into C++, read the #Rust book. It will instantly make you a better C++ programmer.

3

4

49

Piotr Sarna

@sarna_dev

7 months

I just peeked into my wife's crocheting book... if she can make a squirrel out of this cryptic notation, pretty sure she can learn x86 assembly in a week.

2

1

48

Piotr Sarna

@sarna_dev

11 months

Next weekend project: tursobox Built on: - @orangepixunlong Plus 2e - @CrucialMemory 500GB SSD over USB - @armbian - @tursodatabase 's sqld SQL server for local dev and tests, always online and <1ms response times. I just need to make sure sqld builds on armv7 first!

1

4

46

Piotr Sarna

@sarna_dev

7 months

My favorite bug hunting blog by far is @ScyllaDB 's , I reread it at least once a year. Looking for more, please leave links to your favorites in the comments!

2

7

45

Piotr Sarna

@sarna_dev

1 year

This is amazing, true power of open-source: 1. @penberg starts hacking on a Rust MVCC implementation based on the Hekaton paper 2. @iavins finds a bug in the paper itself, confirms it with the authors 3. @iavins posts a fix along with tests that prove the case

Pekka Enberg

@penberg

1 year

First MVCC bug found *in the paper* by @iavins ! Nice work!

0

3

23

1

6

39

Piotr Sarna

@sarna_dev

11 months

Brilliant pattern by @TigerBeetleDB and @ziglang : pass an allocator only as a parameter, so you know if a function allocates just by looking at its params. I fully recommend the whole talk!

Cynthia Dunlop

@c_a_dunlop

11 months

@DominikTornow @TigerBeetleDB Definitely 🔥! The video and deck are now available at

1

8

29

0

3

40

Piotr Sarna

@sarna_dev

7 months

⊕ XOR appreciation thread ⊕ XOR is such a powerful function. So simple that toddlers understand it, cheap on any CPU (1 op), can be implemented in hardware with a single logic gate, and yet it powers the modern cryptography. Some of its magic properties are: 1. A ⊕ 0 = A 2.

0

37

Piotr Sarna

@sarna_dev

1 year

You know what fits into @tursodatabase free tier? An entire IPv4 geolocation table. It's 280MiB, so instead of using external services, you can just put it next to your data and get everything with a local SQL query. Neat!

1

6

35

Piotr Sarna

@sarna_dev

7 months

🏁 BEGIN EXCLUSIVE appreciation thread 🏁 SQLite transactions are lazy by default -- they only take a write lock when necessary. If your transactions start readonly and then upgrade to writes: ``` BEGIN SELECT ... INSERT ... COMMIT ``` , it may be better to just declare it a

0

4

32

Piotr Sarna

@sarna_dev

11 months

Restocked. Now more of my family and friends who have no clue what a database is can get a priceless gift!

4

5

31

Piotr Sarna

@sarna_dev

11 months

Cursor ( @cursor_ai ) just correctly rewrote my whole Rust project by removing all unwrap()s and propagating the errors properly. Super ergonomic

2

0

31

Piotr Sarna

@sarna_dev

1 year

What I find brilliant is that you get fast reads, fast writes, and only pay on the restore path. On writes, deterministic SQL statements are stored in the log, but the in-memory page cache is updated with a proper b-tree page. That makes the read path unchanged, because it reads

Pekka Enberg

@penberg

1 year

The crux of the paper is that they attempt to solve the write amplification problem in SQLite with logical logging. That is, instead writing out pages, they log the SQL statements after non-deterministic parts are evaluated.

2

0

6

3

0

29

Piotr Sarna

@sarna_dev

7 months

C is at the same time the greatest language. For some reason I still like it, even after going through hell like this countless times

Glauber Costa

@glcst

7 months

C is not just a bad language. It is a demonic instrument, that leaves scars on your soul that not even time can heal. We had a small bug recently where one extension that works with SQLite stopped working with libSQL. One of our engineers, @iavins , spent a whole day debugging

121

227

2K

1

0

27

Piotr Sarna

@sarna_dev

1 year

A significant open-source contribution from @realwasmedge folks just landed in @libsqlhq : improved memory allocation, WASI support and more efficient type translation for #wasm user-defined functions. Thanks! #WebAssembly

Optimize the wasm memory allocation mode by L-jasmine · Pull Request #145 · tursodatabase/libsql

About fix: load wasi_nn plugin: On WasmEdge 0.11.2 . When load wasi_nn plugin, we need call WasmEdge_ConfigureAddHostRegistration(ConfCxt, WasmEdge_HostRegistration_WasiNN);. But On WasmEdge 0.12.0...

github.com

0

6

25

Piotr Sarna

@sarna_dev

1 year

Really nice touch by @SpringerNature to also publish each chapter of Database Performance at Scale as independent PDF: Only care about database drivers? No problem, here's a mini-ebook for you. Neat!

Database Performance at Scale

link.springer.com

0

2

23

Piotr Sarna

@sarna_dev

1 year

Exactly! The only acceptable way is to store a database in an image, which is perfectly doable with #SQLite and a little bit of steganography. The pic of my dog attached to this tweet contains the database, go ahead and verify with `steghide`! Passphrase "dog"

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Don’t store images in database, please

194

136

2K

0

3

21

Piotr Sarna

@sarna_dev

1 year

Oh look, my @ScyllaDB and @libsqlhq Wasm UDF babies have grown so much that they get featured in articles 🥹

dylibso

@dylibso

1 year

Compute to data? Polyglot UDFs? #WebAssembly is bringing exciting new ways for developers to make use of their data without having to move data into external applications. Learn why this is a big deal for security, performance, and database accessibility:

1

8

26

2

3

21

Piotr Sarna

@sarna_dev

1 year

I already use embedded replicas at home for all kinds of weekend projects: my local @Raspberry_Pi server syncs with @tursodatabase to get fresh data, and all reads are local, so super fast, and free - you're just reading from your own disk👇

Turso

@tursodatabase

1 year

🎁Tuesday Launch (2/5)🎁 Introducing... ♾Unlimited Embedded Replicas♾ ...for every Turso user. So you can deploy anywhere, even inside your own infrastructure. Read all about it 👇

9

14

145

0

2

19

Piotr Sarna

@sarna_dev

11 months

Approaches to limited memory conditions by standard libraries: C: return NULL C++: throw std::bad_alloc Zig: pass your own allocator, return OutOfMemory Rust: lol what do you mean out of memory 🤪

2

0

19

Piotr Sarna

@sarna_dev

2 years

My libSQL talk from ScyllaDB Summit 2023 is available here: Check out all the other presentations too, the agenda was really great, thanks @ScyllaDB for having me!

0

3

20

Piotr Sarna

@sarna_dev

1 year

Spent full 15 minutes today pair programming with ChatGPT in order to create a documentation lookup tool for #SQLite opcodes, served right from @fermyontech Spin. 100% worth it, already saved me more time while hacking on new experimental @libsqlhq syntax! Example:

1

5

18

Piotr Sarna

@sarna_dev

1 year

Here's the recording of my @wasm_io 2023 talk on @libsqlhq and #WebAssembly user-defined functions, enjoy! And thanks @sergialmar for uploading everything so quickly

Wasm I/O

@wasm_io

1 year

🧩 WebAssembly functions for your SQLite-compatible database by @sarna_dev @ Wasm I/O 2023 ▶️ Video: 🔗 Slides: #wasmio23

1

3

13

1

3

18

Piotr Sarna

@sarna_dev

1 year

Contrary to popular belief, the hardest code to review isn't Linux Kernel, obfuscated Lisp, or C++ metaprogramming. It's the code your CEO posted after a murderous 3 day hackathon.

Glauber Costa

@glcst

1 year

Coded a lot the past 3 days. It is dangerous for me. Addictive. Too easy to rationalize that I should do more, but then other functions suffer

3

0

18

1

17

Piotr Sarna

@sarna_dev

7 months

It's probably just Rust fatigue speaking, but I miss Seastar

Avi Kivity

@AviKivity

7 months

#Seastar now supports C++20 and C++23, and dropped support for C++17.

1

10

47

2

0

17

Piotr Sarna

@sarna_dev

10 months

Thanks for a very interesting discussion @vaibhaw_vipul !👇

Vipul Vaibhaw

@vaibhaw_vipul

10 months

🎙️Ep 20 - Database Performance at Scale with @sarna_dev . Piotr is one of the co-authors of the famous book "Database Performance at Scale". In this episode we dive deep into - understanding performance wrt to databases - zig vs rust - importance of database drivers, etc.

2

14

71

1

2

16

Piotr Sarna

@sarna_dev

2 years

The user-defined functions backend for #WebAssembly , coded entirely in #Rust and Wasmtime, coming soon to #libSQL . Here's a preview: Next on the list - exploring integration with WasmEdge

0

3

16

Piotr Sarna

@sarna_dev

10 months

At first I thought it weird that @ziglang 's errors are just an enum, no payload. But maybe it makes sense... It encourages you not to use error-driven programming, where you encode program logic in throw/catch unwinding. Instead, errors are only used for communicating what

1

0

15

Piotr Sarna

@sarna_dev

1 year

Just recorded my session for @p99conf . All smooth, except one embarassing misunderstanding when they suggested I smile, fully knowing I'm Polish and it's not a legal facial expression around here... Looking forward to the conference! Agenda available here:

P99CONF

@P99CONF

1 year

Can getting rid of #WebAssembly improve your latency? 🤔 We can't wait to hear @sarna_dev 's #P99CONF presentation on combining your code with the #Rustlang toolchain can lead to faster load times. Save your free & virtual spot today: #ScyllaDB #Rust #P99

0

5

14

2

1

15

Piotr Sarna

@sarna_dev

11 months

Update: tursobox already serving queries💪 I just needed to disable Wasm support, since armv7 support for @bytecodeallies 's wasmtime is not cooked yet. Main conclusion is that @orangepixunlong makes for a great local dev server for @tursodatabase 's sqld!

Piotr Sarna

@sarna_dev

11 months

Next weekend project: tursobox Built on: - @orangepixunlong Plus 2e - @CrucialMemory 500GB SSD over USB - @armbian - @tursodatabase 's sqld SQL server for local dev and tests, always online and <1ms response times. I just need to make sure sqld builds on armv7 first!

1

4

46

1

14

Piotr Sarna

@sarna_dev

11 months

Live testing of the new lock stealing patch for @tursodatabase 's sqld. Transactions can now execute for longer than the original 5s limit, but they will be preempted by new transactions if they passed the limit. Nice improvement!

0

1

15

Piotr Sarna

@sarna_dev

1 year

Here's a trick I use to remember the Little's law equation - think units. Throughput is measured in 1/second, average latency is in seconds, and concurrency is just a number, so for the units to match, concurrency = throughput x latency.

Pekka Enberg

@penberg

1 year

Little's Law is a great tool to have in your toolbox when building for low latency! Little's Law is a theorem within mathematical queuing theory, which we use to describe the connection between latency, throughput, and concurrency within computing systems

1

12

67

0

3

14

Piotr Sarna

@sarna_dev

2 years

Just trimmed another ~50% of Wasm module size compiled from Rust by recompiling std lib with abort on panic. The demo user-defined encryption function for #libSQL now occupies 24KiB, used to be 44KiB.

1

3

14

Piotr Sarna

@sarna_dev

10 months

I'm tech reviewing that one 👇 Great read so far!

Bo Ingram

@Boluptuous

10 months

I WROTE A BOOK! ScyllaDB in Action () is now in early access! It's a practical book on how to use and operate ScyllaDB, a scalable NoSQL DB. Use code mlingram for 45% off until 11/14! @LearnwithManning @ManningBooks #LearnwithManning #ManningBooks

3

11

48

1

3

14

Piotr Sarna

@sarna_dev

9 months

How come I only learned about @llvmorg 's lldb today... looks like a great alternative to gdb for quick debugging. Loaded the symbols much more quickly, and the interface is way more intuitive, even if you're already proficient with gdb.

0

13

Piotr Sarna

@sarna_dev

2 years

I highly recommend this one, it's a great deep dive into how I/O actually works (and a rare opportunity to watch Avi talk in outer space!). My personal favorite from @P99CONF

Avi Kivity

@AviKivity

2 years

My @P99CONF talk. This one is rather different, instead of reading some slides I narrate an animated movie featuring a disk and a database.

1

20

62

1

3

13

Piotr Sarna

@sarna_dev

11 months

@KunalSin9h It sums up good C++ practices. Makes you realize variables should be const by default, std::move should be default semantics for passing values, slices give you a good perspective of why things like std::string_view make sense, etc.

1

0

13

Piotr Sarna

@sarna_dev

7 months

Defining your SQLite table with foreign keys and ON DELETE CASCADE sounds like great idea for integrity, but it can also kill your query performance. Say you have two tables: ``` CREATE TABLE cities(id INT PRIMARY KEY, name TEXT); CREATE TABLE restaurants( id INT PRIMARY KEY,

0

2

12

Piotr Sarna

@sarna_dev

7 months

cargo build --timings gives nice insights into compilation times per crate

0

1

9

Piotr Sarna

@sarna_dev

11 months

Back in the days I led @ScyllaDB 's Rust driver, I wrote a tool for comparing our project against other popular drivers. I checked back, and looks like ScyllaDB Rust driver became the absolute default choice, congrats to the dev team!

0

1

11

Piotr Sarna

@sarna_dev

9 months

👇 SQLite3MultipleCiphers is super promising for giving @tursodatabase encryption at rest, the demo already works! I hardcoded the encryption passphrase to "heyhey" for now, not sure if it passes all SOC2 requirements -- I need to contact my lawyer wrt. that.

Pekka Enberg

@penberg

9 months

One of the things I've wanted to do for a long time is enable encryption at rest in Turso for embedded replicas but also on the server side. Looking forward to seeing if @sarna_dev can pull of integrating into libSQL:

0

11

0

3

11

Piotr Sarna

@sarna_dev

11 months

@iavins @glcst @gwenshap @TigerBeetleDB @P99CONF is the best online conference ever, and this year it also has the best lineup ever

0

1

11

Piotr Sarna

@sarna_dev

1 year

A @ziglang *contributor* ( ͡° ͜ʖ ͡°) . Jokes aside, it was really refreshing be able to just fix whatever you need right in the standard library code in `/usr/lib64/zig`, and then push the fix upstream. Distributing the standard library as code is one of the things that make Zig

Pekka Enberg

@penberg

1 year

While @sarna_dev was working on pg_turso, he at some point proclaimed that he had become a @ziglang programmer. Luckily for me, he's since then also agreed to write some @rustlang . I didn't do any of the work, but Zig worked really great for writing an PostgreSQL extension!

1

7

0

1

10

Piotr Sarna

@sarna_dev

1 year

@andresmargalef @c_a_dunlop @cardeneti82118 @ScyllaDB @Apress It's going to be released as an Apress Open title (), so it will be available for free as PDF or epub, as far as I know

ApressOpen Browse Titles

Learn more about Apress' open source content, how to publish with ApressOpen, and browse out freely available quality content.

www.apress.com

0

1

11

Piotr Sarna

@sarna_dev

1 year

Huge congrats to @PostgreSQL for the 1st place in @StackOverflow developer survey 2023, but what I find most interesting is that #SQLite is doing so well among all the distributed systems on the list. Shows how important it is to have a local database engine around!

0

3

11

Piotr Sarna

@sarna_dev

1 year

My takeaways from @wasm_io 2023, day 1: 1/5 I'm glad to see that the presentations weren't browser-centric at all - #WebAssembly is considered to be the go-to language for virtualization, serverless, edge functions. As it very well should be!

1

4

11

Piotr Sarna

@sarna_dev

1 year

@phamduchieu @c_a_dunlop @cardeneti82118 @ScyllaDB @Apress It is already -

Database Performance at Scale

link.springer.com

1

10

Piotr Sarna

@sarna_dev

1 year

Am I the only person suffering from microcontroller OCD? I need to regularly browse for @arduino , @Raspberry_Pi and all kinds of sensors and add-ons for them, just to eventually convince myself that I already have a full cabinet of those, some of it never used. That said, some

1

10

Piotr Sarna

@sarna_dev

1 year

Pitfall of the day: if you use mimalloc in your Rust project, beware that it runs in secure mode by default: . Secure mode is great against memory exploits, but lots of use cases don't need that. The penalty? After ditching secure mode, resident memory

GitHub - purpleprotocol/mimalloc_rust: A Rust wrapper over Microsoft's MiMalloc memory allocator

A Rust wrapper over Microsoft's MiMalloc memory allocator - purpleprotocol/mimalloc_rust

github.com

0

1

10

Piotr Sarna

@sarna_dev

9 months

As usual, @penberg 's post on how he's clueless about some subject created a goldmine of resources. Highly recommend the comment section of that one! 👇

Pekka Enberg

@penberg

9 months

I have some really basic understanding of GPU programming with shaders and CUDA, but am mostly clueless of actual GPU architecture and how code gets executed on it. What books or blog posts would you recommend me to read to catch up?

31

59

746

0

10

Piotr Sarna

@sarna_dev

1 year

Native CRDT support will allow developers to write offline-first apps with a proper database engine - libSQL. And the fact that it's a community contribution makes it 1000x more exciting!

Matt Wonlaw

@tantaman

1 year

One of the things I'm most excited for is partnering with the LibSQL folks to create a custom syntax for defining tables which are backed by CRDTs! LibSQL is truly getting SQLite ready for the coming decades --

5

26

163

0

10

Piotr Sarna

@sarna_dev

9 months

@awakecoding @tursodatabase @The_Pi_Hole Turso speaks over HTTP or websockets, ref: . And as for availability, we have replicas ( ) and regular backups for disaster recovery

Quickstart - Turso

Welcome to Turso! Get started with Turso in minutes.

docs.turso.tech

Glauber Costa

@glcst

9 months

Turso is available over raw HTTP for stateless communication. If your language doesn't have a supported Turso SDK, you can still enjoy most of Turso like this.

1

17

1

0

10

Piotr Sarna

@sarna_dev

7 months

Wait, so now I don't have to rewrite a distributed system from scratch to get deterministic tests for it? 😍

Antithesis

@AntithesisHQ

7 months

It’s a big day for us – after over 5 years, we’re out of stealth! We’ve built a completely new approach to software reliability testing. We find bugs autonomously, with 100% reproducibility. Check out our launch blog post for way more info!

3

44

144

0

10

Piotr Sarna

@sarna_dev

1 year

#Linux is amazing - just upgraded my laptop disk from 1 to 2TiB as follows: 1. Connect the new disk via USB adaptor 2. dd if=/dev/nvme0n1 of=/dev/sdc conv=noerror,sync bs=4K status=progress from a live disk, the one currently used by my #archlinux 3. Use gparted to resize the

0

10

Piotr Sarna

@sarna_dev

1 year

Heading to Barcelona, take-off in 5 minutes. See you there at @wasm_io 2023!

Piotr Sarna

@sarna_dev

2 years

Join me in Barcelona! My talk on @libsqlhq is at 12:30, March 23rd

0

1

3

1

0

9

Piotr Sarna

@sarna_dev

10 months

I hit an interesting bug when using cargo lambda, based on cargo zigbuild, to create an @awscloud Lambda app with @tursodatabase 's embedded replicas. libSQL kept failing on opening the db, and some gdb sessions later I realized it failed during lstat syscall, which returned

1

0

9

Piotr Sarna

@sarna_dev

2 years

A perfect day for a short @libsqlhq morning hackathon. 0.2.0 release coming soon, cooked in-between skiing sessions

1

9

Piotr Sarna

@sarna_dev

7 months

time for @poolsideai

4

0

8

Piotr Sarna

@sarna_dev

10 months

When boss lets you expense @openai 's ChatGPT Plus for "AI assistance on @tursodatabase hacking", but you're more into generating cool story books for your daughter. The Case of Missing Gooseberries:

1

0

8

Piotr Sarna

@sarna_dev

1 year

I really enjoyed the @ziglang adventure! 👇

Glauber Costa

@glcst

1 year

And here it is: We decided to write pg_turso in Zig, and it was absolutely the right choice. But are we rewriting everything in Zig? No, not yet. Read more and draw from @sarna_dev 's experience!

5

23

128

1

0

8

Piotr Sarna

@sarna_dev

11 months

Today @ziglang made me realize: people swear they never use global variables in their life (obvious antipattern), and then happily malloc() if they need memory...

0

2

7

Piotr Sarna

@sarna_dev

1 year

Data edge in practice: I tested how long it takes for my weekend project to contact @TursoDatabase in 2 cases: 1. single db instance in New Jersey 2. extra local replica in Warsaw Results: humble 32x faster response after: $ turso db replicate mail_db waw Details soon!

0

3

8

Piotr Sarna

@sarna_dev

1 year

3/5 It was very nice to see @emaxerrno 's Redpanda mentioned a couple of times. I consider @redpandadata one of the early adopters of #Wasm , and it was in fact their implementation that inspired me to add Wasm-based user-defined functions to @ScyllaDB (and later @libsqlhq ofc!)

1

0

8

Piotr Sarna

@sarna_dev

9 months

Since when does @github Copilot have a chat? I just tried it on a very non-obvious, tricky #SQLite implementation detail, and it nailed the answer. Nice!

1

0

8

Piotr Sarna

@sarna_dev

1 year

👇 @P99CONF has really amazing lineup this year

P99CONF

@P99CONF

1 year

Given #P99CONF 's focus on low-latency engineering strategies, it's not surprising that #Rustlang has been a trending topic since day 1. With over 50 tech talks over two half days, we wanted to share a sneak peek into some of the Rust-focused talks we'll be featuring. Here are

0

4

15

0

1

8

Piotr Sarna

@sarna_dev

1 year

I went a step further and implemented a @telegram bot for looking up #SQLite (and @libsqlhq ) opcodes. It's really amazing how easy it is to hack your own bot, backed by Fermyon's @spinframework . Each time you send a message, Telegram server sends a request to my Spin app, all

Piotr Sarna

@sarna_dev

1 year

Spent full 15 minutes today pair programming with ChatGPT in order to create a documentation lookup tool for #SQLite opcodes, served right from @fermyontech Spin. 100% worth it, already saved me more time while hacking on new experimental @libsqlhq syntax! Example:

1

5

18

1

3

8

Piotr Sarna

@sarna_dev

10 months

👇if you're one of those hopeless people that actually enjoy discussions on B-Tree internals, join us on the live panel!

Cynthia Dunlop

@c_a_dunlop

10 months

TOMORROW - #ScyllaDB is hosting a [free + virtual] "Database Performance at Scale masterclass" on Wednesday, taught by authors of the book. We'll cover the impact of workload characteristics, database internals, database driver optimizations & more.

0

1

17

0

3

8

Piotr Sarna

@sarna_dev

9 months

Turns out @Google Bard has extremely good taste in tech literature

1

8

Piotr Sarna

@sarna_dev

1 year

Here's why pushing data to the edge makes so much sense — without middlemen, you can get your data in less than 30ms total, especially if those middlemen happen to be on another continent. (While it may be shocking to some, not everyone lives in close proximity to us-east-2 😇).

Piotr Jastrzebski

@haaawk_dev

1 year

Get your data in 28ms - that's what Data @Edge means! Inspired by an amazing @vercel latency playground by @leeerob , I decided to add an option to test the latency of the browser calling straight to the DB. For my location (Warsaw), I can get data from @tursodatabase in 28ms :).🧵

4

14

0

2

8

Piotr Sarna

@sarna_dev

1 year

Today I learned that NVMe PCIe to USB adaptors exist and cost $10. And that means my old laptop SSD will gain a second life as a very compact (barely 3.5'') external 1TiB drive.

1

7

Piotr Sarna

@sarna_dev

2 years

Getting your passwords automatically encrypted in @libsqlhq , powered by triggers, #WebAssembly , #Rust and :

0

2

7

Piotr Sarna

@sarna_dev

1 year

I wish I realized sooner that KubeCon was going to co-host CloudNativeWasm day... I'll save the talk submission for next year, and meanwhile I recommend everyone to attend, esp. that @fermyontech supports the event -- these guys tend to make conferences awesome (ref: @wasm_io )

Kubecon_

@KubeCon_

1 year

#KubeCon + #CloudNativeCon Europe co-lo #CloudNativeWasm Day will highlight the growing importance and ubiquity of WebAssembly throughout the cloud native ecosystem 🙌 Thank you to diamond sponsors @fermyontech + @Docker for supporting the event!

0

8

28

2

1

7

Piotr Sarna

@sarna_dev

1 year

Highly recommend this one👇

Vipul Vaibhaw

@vaibhaw_vipul

1 year

🎙️Ep. 15 - Understanding @tursodatabase with @penberg 🚀💡 It was such an insightful discussion for me - - Cpu-centric POSIX - PhD and Startups - Unravelling TursoDB - why embedded database? The HA choice for Turso, etc. #TheDistributedFabricPod

3

10

41

1

0

7

Piotr Sarna

@sarna_dev

1 year

I wanted to write my own disposable email server for a long while, and what better time for that than office hours 😇 and that's how was born! Enjoy

Turso

@tursodatabase

1 year

Need a temporary email address? @sarna_dev explains how he built a service from scratch with #Turso and @rustlang , free to use, and with full source code available. Start reading here:

0

8

24

3

0

7

Piotr Sarna

@sarna_dev

1 year

I'm really proud @tursodatabase is part of this. Cloudflare folks provide so many innovations that one can't really imagine the Internet without them anymore 🤷

Cloudflare

@Cloudflare

1 year

Earlier this year, we introduced integrations with Supabase, PlanetScale, Neon and Upstash. Today, we are thrilled to introduce our newest additions to Cloudflare’s Integrations Marketplace – Sentry, Turso and Momento. #BirthdayWeek

0

12

69

0

7

Piotr Sarna

@sarna_dev

10 months

Day 72 of reverse-engineering my sauna. Behold my newest invention: Ethernet cable inspector! How did I get there?

2

0

7

Piotr Sarna

@sarna_dev

2 years

@gunnarmorling @gunnarmorling this is precisely why WAL2 mode was introduced to SQLite, give it a try!

1

7

Piotr Sarna

@sarna_dev

8 months

Playing with per-database encryption for @tursodatabase , powered by SQLite3MultipleCiphers extension:

0

3

7

Piotr Sarna

@sarna_dev

9 months

github1s is one of my favorite hacks. Just add "1s" to the repo URL and get a fully functional vscode in the browser for quick code inspection.

2

0

7

Piotr Sarna

@sarna_dev

7 months

Thanks @perplexity_ai , learned about PRAGMA defer_foreign_keys today, precisely what I wanted.

0

6

Piotr Sarna

@sarna_dev

2 years

That's going to be my first onsite talk in a looong while, looking forward to it! Spoiler alert: maybe I'll also slip in a bonus slide or two on how to connect to libSQL from native Wasm environments like @fermyontech 's spin and @cloudflaretech 's Workers😇

Wasm I/O

@wasm_io

2 years

Learn about @libsqlhq , a fork of SQLite, and its support for dynamic function creation and execution directly via SQL, all powered by Wasm in @sarna_dev 's talk "WebAssembly functions for your SQLite-compatible database" #wasmio23

0

7

19

2

3

6

Piotr Sarna

@sarna_dev

1 year

Great summary of @wasm_io 2023. Already looking forward to Wasm I/O 2024!

Fermyon

@fermyontech

1 year

What does a violinist and a drummer have to do with WebAssembly? Check out the @wasm_io wrap up blog from @technosophos to find out.

0

8

30

0

6

Piotr Sarna

@sarna_dev

8 months

Ask yourself an opposite: why shouldn't I pick SQLite as my production database? In most cases you won't have a single reason not to

Pekka Enberg

@penberg

8 months

When should you pick SQLite as your production database? Although many people are (re-)discovering SQLite, there are still a lot of popular myths about it, but perhaps also some hype that fails to mention the downsides. First and foremost, SQLite is a versatile,

8

29

153

0

6

Piotr Sarna

@sarna_dev

7 months

Working on this 👇 was exactly what lured me back to hacking challenges... couldn't resist after seeing the keyword AES so many times.

Glauber Costa

@glcst

7 months

Today, we are adding encryption-at-rest natively to libSQL. It is fully OSS, and all you have to is to add a key parameter to the constructor. This works for local files, and you don't even have to be a Turso user for that. SQLite doesn't have encryption at rest as an Open

8

26

239

0

6

Piotr Sarna

@sarna_dev

1 year

As a heavy user of , I decided to start working on a clone, powered by @ChiselStrike Turso and @libsqlhq . Half-baked, but works! All e-mails sent to the @ domain will be printed on the webpage:

1

5

6

Piotr Sarna

@sarna_dev

1 year

That's going to unlock very interesting use-cases for @libsqlhq as well - we already have all the code merged from upstream SQLite. Can't wait to give `./configure --with-wasi-sdk=$WASI_SDK_PATH` a try!

Wasm Labs

@vmwwasm

1 year

We are happy to share that #SQLite has out of the box support for wasm32-wasi since 3.41.0. Here you have the story behind those changes and how we collaborated with the SQLite team 🤩 #webassembly

1

8

34

1

0

6

Piotr Sarna

@sarna_dev

8 months

@penberg @bebraw @stackblitz 100%, libSQL already compiles to wasm in WAL mode, and that's all we need for embedded replicas in a browser.

1

0

6

Piotr Sarna

@sarna_dev

11 months

keep the positive reviews coming 😻

Alex DeBrie

@alexbdebrie

11 months

Damn, this is an excellent resource. I read the first few chapters closely and plan to return to the rest. Lots of interesting stuff + frank discussion of how to truly evaluate different database options. Also, helpful hints for sounding smart 🤓. Very good tone throughout!

6

13

59

0

1

6

Piotr Sarna

@sarna_dev

1 year

4/5 Now that @libsqlhq user-defined functions can run both on Wasmtime and @wasmedge , I wonder if @ScyllaDB wouldn't benefit from a second runtime as well, esp. if the "reactor stalls" issue could be solved with tools like asyncify (). Food for thought ;)

Rust Tokio integration for asyncify · Issue #1664 · WasmEdge/WasmEdge

The asyncify toolkit from Binaryen provides an easy way to transform any Wasm bytecode app to be ready for async/await operations. We would like to provide a simple demo to show how to call asyncif...

github.com

1

0

6

Piotr Sarna

@sarna_dev

11 months

One weekend project I actually use is disposable email: . What I really like about it -- any username works, so you can sign up on any webpage without generating the inbox first, and later just check the email. Nice alternative to !

0

6

Piotr Sarna

@sarna_dev

1 year

2/5 I really enjoyed all the off-stage conversations, it's nice to see that both speakers and attendees are really serious about #Wasm , you can learn a lot just by being there. I'm definitely up for WasmIO 2024.

1

0

5

Piotr Sarna

@sarna_dev

2 years

libSQL 0.2.0 is here!

libSQL

@libsqlhq

2 years

We are pleased to announce new versions of core #libSQL and its server sqld. Read the release notes for libSQL 0.2.0 here: And for sqld 0.3.3 here:

1

2

16

0

1

5

Piotr Sarna

@sarna_dev

8 months

I really need to get back to , I already got stuck 2 times at Challenge Set 3, this is an immensely educational page. (and it's crypto as in cryptography, the cool one)

0

5

Piotr Sarna

@sarna_dev

1 year

@glcst when joining @ScyllaDB , my first thought after learning about the company history was "I wish I found these guys before they pivoted from @OSv_unikernel , sounds like the coolest project ever"

1

0

5

Piotr Sarna

@sarna_dev

9 months

@LambrosPetrou @tursodatabase @The_Pi_Hole The scenario tested here is "database per user", so there's no common schema to coordinate - each user can store whatever they wish in the db

1

5