Hacker GitHub

← All repos

bittorrent/sqltorrent

View on GitHub ↗ ★ 287 C

14 mentions on Hacker News by 9 people: 2 stories, 12 comments · first 2017-03-14 · latest 2024-04-16

Mentions per year 14 mentions · busiest year 2020 (4)
20082026
AllStoriesComments NewestTopOldest
  1. …sqlite file that is full-text-search indexed. Then you can full-text search the torrent on demand: https://github.com/bittorrent/sqltorrent
    comment by sktrdie · 2024-04-16 · in BTFS: BitTorrent Filesystem
  2. …sql.js-httpvfs, DuckDB https://news.ycombinator.com/item?id=28021766 #. >> - bittorrent/sqltorrent https://github.com/bittorrent/sqltorrent >> Sqltorrent is a custom VFS for sqlite which allows applications to query an sqlite database…
    comment by westurner · 2023-08-09 · in SQLedge: Replicate Postgres to SQLite on the Edge
  3. …https://github.com/phiresky/sql.js-httpvfs#inspiration 2: https://github.com/lmatteis/torrent-net 3: https://github.com/bittorrent/sqltorrent
    comment by samwillis · 2022-01-13 · in Database-less torrent website
  4. …by looking at the “Access pattern” column in the page read log above. > - bittorrent/sqltorrent https://github.com/bittorrent/sqltorrent >> Sqltorrent is a custom VFS for sqlite which allows applications to query an sqlite database…
    comment by westurner · 2021-07-31 · in Hosting SQLite Databases on GitHub Pages
  5. …and partial downloads to enable searches on a database before it was downloaded all the way." https://github.com/bittorrent/sqltorrent
    comment by o8r3oFTZPE · 2021-06-09 · in How to circumvent Sci-Hub ISP block
  6. See also https://github.com/bittorrent/sqltorrent , same trick but using BitTorrent
    comment by misterdata · 2021-05-02 · in Hosting SQLite databases on GitHub Pages or any static file hoster
  7. …of bytes that SQLite wants to read by the size of the torrent blocks. It is just a division. See: https://github.com/bittorrent/sqltorrent/blob/master/sqltorr...
    comment by frafra · 2021-01-20 · in Distributed search engines using BitTorrent and SQLite
  8. …similar (selectively load the SQLite DB on demand), albeit with the SQLite file in a torrent. [1]: https://github.com/bittorrent/sqltorrent
    comment by woadwarrior01 · 2020-06-10 · in A tiny static full-text search engine using Rust and WebAssembly (2019)
  9. …for instance. Then let the users seed it. Users can use sqltorrent Virtual File System ( https://github.com/bittorrent/sqltorrent ) to query the db without downloading the entire torrent - essentially it knows to download only the pieces…
    comment by sktrdie · 2020-05-14 · in Hyperdrive v10 – a peer-to-peer filesystem
  10. …Then put the file in a torrent. Let the users seed it. Users can use sqltorrent ( https://github.com/bittorrent/sqltorrent ) to query the db without downloading the entire torrent - essentially it knows to download only the pieces of the to
    comment by sktrdie · 2020-05-12 · in Thank you for helping us increase our bandwidth
  11. A very interesting approach is sqltorrent ( https://github.com/bittorrent/sqltorrent ): the sqlite file is shared in a torrent, and all queries will touch a specific part of the file, which is downloaded on-demand. Also check…
    comment by rakoo · 2020-01-26 · in SQLite Is Serverless
  12. …I'm not sure about the "community". The credit for this idea goes mostly to the person behind https://github.com/bittorrent/sqltorrent - but I don't think there are projects using this technique just yet. I'm hoping TorrentPeek can become…
    comment by sktrdie · 2017-04-17 · in Show HN: TorrentPeek – Distributed search engines using BitTorrent and SQLite