Trying DuckDB Database For The First Time P1 | Tech Discovery Series
My Gaming Channel 🎮 / @mgc2267
Join this channel ❤️
/ @monkhaus
In this video we luck at DuckDb. In particular I do a couple of things. I compare duckdb vs sqlite at various tasks such inserts and fetching data. I talk about the use cases of duckdb. Overall it's a pretty fun video where we just talk about duckdb in general.
In general this series is about exploring new technologies (mostly web technologies and tools) and trying them out for the first time.
00:00 intro
00:35 Purpose of the video
00:52 Moaning about tech jargon because I'm dumb
01:12 Moaning about JS frameworks
01:21 OLAP vs OLTP quickie
02:20 My 2 Python scripts
03:00 How I setup the scripts
03:30 Execute test scripts
04:35 Initial results of DuckDB vs SQLite
05:12 Modified the code + more data
05:31 DuckDB vs SQLite P2 HOLY MOLY
05:54 Results P2
06:25 DuckDB use case
07:05 Elephant in the room
08:15 Rambling
09:35 Practical example for DuckDB + conclusion
