正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

Loading 500K Rows from SQLite Database Using SwiftData.

Mohammad Azam

20,865 subscribers

34,262 次观看 • 5 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

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.

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,367 次观看 • 5 个月前

Delete blank rows using Excel shortcut keys

Delete blank rows using Excel shortcut keys

Computer Knowledge

13,266 次观看 • 6 个月前

Stop Using Your Biceps on Cable Rows!

Stop Using Your Biceps on Cable Rows!

Awaken The Alphaa

614,833 次观看 • 5 个月前

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.

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,649 次观看 • 1 年前

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.

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

299,865 次观看 • 7 个月前

Kevin Maguire says its clear Reform are using the murder of Anne Widdecombe as a diversion from rows over 'gifts' and donations.

Kevin Maguire says its clear Reform are using the murder of Anne Widdecombe as a diversion from rows over 'gifts' and donations.

Saul Staniforth

834,604 次观看 • 3 个月前

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

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

Melvin Vivas

72,226 次观看 • 10 个月前

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.

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

212,679 次观看 • 6 个月前

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

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,762 次观看 • 1 年前

Codex tip: Build and deploy APIs with Sites Not just web apps. Below is a JSON API using Hono, database storage, typed Drizzle queries, and a live database viewer. It was all built, deployed, and managed from Codex - with the web frontend. Bonus: Had Codex generate and run database migrations.

Codex tip: Build and deploy APIs with Sites Not just web apps. Below is a JSON API using Hono, database storage, typed Drizzle queries, and a live database viewer. It was all built, deployed, and managed from Codex - with the web frontend. Bonus: Had Codex generate and run database migrations.

Stephen

11,778 次观看 • 3 个月前

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. 🌱

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 次观看 • 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:

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,389 次观看 • 3 年前

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

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

Mohammad Azam

18,052 次观看 • 1 年前

Building Vector Database from Scratch

Building Vector Database from Scratch

Mohit Mishra

23,126 次观看 • 1 年前

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.

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,595 次观看 • 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!

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,850 次观看 • 1 年前