Загрузка видео...

Не удалось загрузить видео

На главную

Loading 500K Rows from SQLite Database Using SwiftData.

azamsharp's profile picture

Mohammad Azam

20,779 subscribers

34,204 просмотров • 14 дней назад •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 0

Нет доступных комментариев

Здесь появятся комментарии из оригинального поста

Похожие видео

Loading CSV files into a database using Python.
15:45

Loading CSV files into a database using Python.

Benjamin Bennett Alexander

41,794 просмотров • 1 год назад

Using Expo with real-time synced SQLite means that instead of having to: • manage network requests • handle loading states • implement retry logic • orchestrate state management between your local cache and remote data You just write queries™
0:24

Using Expo with real-time synced SQLite means that instead of having to: • manage network requests • handle loading states • implement retry logic • orchestrate state management between your local cache and remote data You just write queries™

PowerSync

51,214 просмотров • 8 месяцев назад

Delete blank rows using Excel shortcut keys
0:20

Delete blank rows using Excel shortcut keys

Computer Knowledge

12,675 просмотров • 1 месяц назад

Stop Using Your Biceps on Cable Rows!
0:43

Stop Using Your Biceps on Cable Rows!

Muscle Freak

608,519 просмотров • 13 дней назад

Part 1 of 12: building a tiny SQLite-style database in C from scratch. Today is the REPL skeleton: the db > command line, getline, .exit, EOF handling, and the loop every future parser, row store, pager, and B-tree feature plugs into. This tiny command shell becomes a database.
3:30

Part 1 of 12: building a tiny SQLite-style database in C from scratch. Today is the REPL skeleton: the db > command line, getline, .exit, EOF handling, and the loop every future parser, row store, pager, and B-tree feature plugs into. This tiny command shell becomes a database.

tetsuo

16,013 просмотров • 15 дней назад

Here is my Vegas DefCon presentation from last week on how to hack the Dominion Voting machines. There is a unprotected SQLite database on the ICX voting machines that can be altered. It also stores the encryption keys in plain text.
3:52

Here is my Vegas DefCon presentation from last week on how to hack the Dominion Voting machines. There is a unprotected SQLite database on the ICX voting machines that can be altered. It also stores the encryption keys in plain text.

Mad Liberals

323,396 просмотров • 9 месяцев назад

Meet Database Agents. A team of li’l librarians in your database — keeping it up to date automatically using context from the page, your workspace, and the web. No more “we’ll update the database later.” Starting to roll out on Biz + Enterprise.
0:34

Meet Database Agents. A team of li’l librarians in your database — keeping it up to date automatically using context from the page, your workspace, and the web. No more “we’ll update the database later.” Starting to roll out on Biz + Enterprise.

Notion

298,702 просмотров • 2 месяцев назад

Opus 4.5 using frontend skill (Claude Pro) landing page + fullstack nextjs with sqlite db one-shot 🔥🔥🔥
0:29

Opus 4.5 using frontend skill (Claude Pro) landing page + fullstack nextjs with sqlite db one-shot 🔥🔥🔥

Melvin Vivas

72,140 просмотров • 6 месяцев назад

Database table size impacts performance in more ways than one: a) B-tree depth. Using 8k pages and a 16b uuid: 1 level = ~370 rows 2 levels = ~138k rows 3 levels = ~50m rows 4 levels = ~20b rows The lookup cost on a table with 100k rows is not the same as one with 1b rows. This can apply both to the table itself (MySQL cluster index) as well as the indexes. Sometimes a single query requires many of them. b) Small table → fits in RAM → fast reads. The larger the table, the more likely to read from disk plus churn the cache. c) # of indexes. Each adds maintenance overhead for insertions, and for Postgres vacuum overhead as well. Keep an eye on this! It's useful to take regular stock of your tables + indexes. Clean bloat. Remove unused indexes. Partition if needed.
0:58

Database table size impacts performance in more ways than one: a) B-tree depth. Using 8k pages and a 16b uuid: 1 level = ~370 rows 2 levels = ~138k rows 3 levels = ~50m rows 4 levels = ~20b rows The lookup cost on a table with 100k rows is not the same as one with 1b rows. This can apply both to the table itself (MySQL cluster index) as well as the indexes. Sometimes a single query requires many of them. b) Small table → fits in RAM → fast reads. The larger the table, the more likely to read from disk plus churn the cache. c) # of indexes. Each adds maintenance overhead for insertions, and for Postgres vacuum overhead as well. Keep an eye on this! It's useful to take regular stock of your tables + indexes. Clean bloat. Remove unused indexes. Partition if needed.

Ben Dicken

211,738 просмотров • 1 месяц назад

SwiftUI + Foundation Models + SwiftData = ♥️ * Persisting your model recommendations
0:30

SwiftUI + Foundation Models + SwiftData = ♥️ * Persisting your model recommendations

Mohammad Azam

18,036 просмотров • 11 месяцев назад

So you can just give it a postgres URL (or sqlite db file) and it will just... explore it and offer to build things. Even with a crazy nonstandard (from Ecto perspective) database. The search bar crashed, I sent the logs to the agent, and boom realtime searching
1:27

So you can just give it a postgres URL (or sqlite db file) and it will just... explore it and offer to build things. Even with a crazy nonstandard (from Ecto perspective) database. The search bar crashed, I sent the logs to the agent, and boom realtime searching

Chris McCord

12,754 просмотров • 1 год назад

I promised a longer video on how to build a full-stack ICP app, powered by SQLite. Here it is! This is a nose to tail walkthrough, we look at database migrations, automatic input validation, DTO objects, performant frontend queries using Tanstack Query and lots more. Links to demo app, libraries and YT video in the responses. 🌱
33:58

I promised a longer video on how to build a full-stack ICP app, powered by SQLite. Here it is! This is a nose to tail walkthrough, we look at database migrations, automatic input validation, DTO objects, performant frontend queries using Tanstack Query and lots more. Links to demo app, libraries and YT video in the responses. 🌱

Kristofer

13,063 просмотров • 8 месяцев назад

Also upcoming in the next update : - Updated FTP backup loader now loading stuff from /data/homebrew & /usb0+1/homebrew - Start games directly from your PS5 backup library using Echo Stretch 's dump_runner Requires loading ftpsrv, websrv & kstuff before.
0:31

Also upcoming in the next update : - Updated FTP backup loader now loading stuff from /data/homebrew & /usb0+1/homebrew - Start games directly from your PS5 backup library using Echo Stretch 's dump_runner Requires loading ftpsrv, websrv & kstuff before.

SvenGDK

12,497 просмотров • 1 год назад

Kyushu University released more than 1500 3D models of animals and plants using a photogrammetry technique, taking digital photos from multiple angles [database: [full paper:
1:00

Kyushu University released more than 1500 3D models of animals and plants using a photogrammetry technique, taking digital photos from multiple angles [database: [full paper:

Massimo

932,251 просмотров • 2 лет назад

Building Vector Database from Scratch
0:57

Building Vector Database from Scratch

Mohit Mishra

23,126 просмотров • 9 месяцев назад

Announcing Realtime Broadcast from Database! Broadcast from Database allows you to broadcast changes happening in your database in a flexible and scalable way. It even supports joining multiple tables to broadcast the payload, opening up new way to listen to database changes!
1:10

Announcing Realtime Broadcast from Database! Broadcast from Database allows you to broadcast changes happening in your database in a flexible and scalable way. It even supports joining multiple tables to broadcast the payload, opening up new way to listen to database changes!

Supabase

33,170 просмотров • 1 год назад

Epicenter (epicenter) is building a database for your mind. They're designing a Svelte ecosystem of apps sharing a local memory: a folder and SQLite file. Open-source, open-format, and fully yours. Congrats on the launch, Braden Wong!
2:11

Epicenter (epicenter) is building a database for your mind. They're designing a Svelte ecosystem of apps sharing a local memory: a folder and SQLite file. Open-source, open-format, and fully yours. Congrats on the launch, Braden Wong!

Y Combinator

17,622 просмотров • 10 месяцев назад

The 1.4 release of DuckDB supports using a DuckDB database to serve vector tiles! Of course, I had to try this out in R. Check it out: all 242,000 US Census block groups dynamically served as vector tiles from a DuckDB database, displayed on a MapLibre map from R in Positron.
0:31

The 1.4 release of DuckDB supports using a DuckDB database to serve vector tiles! Of course, I had to try this out in R. Check it out: all 242,000 US Census block groups dynamically served as vector tiles from a DuckDB database, displayed on a MapLibre map from R in Positron.

Kyle Walker

45,463 просмотров • 7 месяцев назад

So you forgot how you fixed that bug the other day. 😬 No worries. GitHub Copilot CLI remembers. With its local SQLite database of your session history (and a full-text search index), you can instantly pull up context from your previous work. ✅ Install Copilot CLI and save brain space. ⬇️
1:10

So you forgot how you fixed that bug the other day. 😬 No worries. GitHub Copilot CLI remembers. With its local SQLite database of your session history (and a full-text search index), you can instantly pull up context from your previous work. ✅ Install Copilot CLI and save brain space. ⬇️

GitHub

46,876 просмотров • 3 месяцев назад

✨Generate✨ can complete ANY task inside a long-running or interactive CLI command. - Database: psql, mysql, sqlite - Cloud provider: gcloud, aws cli - Text editor: vim, nano - Python REPL: ipython, python - Debugger tools: gdb, lldb - Version control: git rebase -i
1:00

✨Generate✨ can complete ANY task inside a long-running or interactive CLI command. - Database: psql, mysql, sqlite - Cloud provider: gcloud, aws cli - Text editor: vim, nano - Python REPL: ipython, python - Debugger tools: gdb, lldb - Version control: git rebase -i

Warp

11,776 просмотров • 1 год назад