Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sktrdie
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
46 ms
·
421.
▲
by
sktrdie
9y ago
But you see, the endpoint of this endeavour is not to eventually find a better job or get the piece of paper. Is to learn something for myself.
422.
▲
Ask HN: Should I go back to academia?
1 points
by
sktrdie
9y ago
|
2 comments
423.
▲
by
sktrdie
9y ago
Actually there were experiments in the original Bitcoin paper. And it would've probably passed a workshop-related setting for academia. More than the academic presentation though, I'm just baffled by the lack of science that these
424.
▲
by
sktrdie
9y ago
Coming from academia, these sort of papers would not pass any sort of double-bind peer review process. Where's the actual science? Where are the experiments? It seems to be just a document describing the protocol of Filecoin, which is
425.
▲
by
sktrdie
9y ago
The whole point is that the miners within the pool can change to other pools if they want to!
426.
▲
by
sktrdie
9y ago
Why is it false? I didn't say "mining is profitable". I just said anybody can do it, and that's the key. Just like anybody can seed torrents without any incentive, or just like Tor nodes exist without any incentive.
427.
▲
by
sktrdie
9y ago
All this "unconsensus" is weird to me given that PoW was created to fix just that. I don't understand how can any other group of people decide what should happen other than the miners. After all, anybody can be a miner. Anyth
428.
▲
by
sktrdie
9y ago
If I had an exchange I would be sure to check on all forks whether certain coins have been used before allowing processing. Since all forks are known, this is probably how they're going to avoid double-spending.
429.
▲
by
sktrdie
9y ago
Rather than thinking about the businesses that currently are trying to get rich by doing ICOs, I'd like to point out that the idea of creating tokens out of thin-air, and having them obtain value purely by speculation, is an interestin
430.
▲
Show HN: TorrentNet – Peer-To-Peer Sites Using BitTorrent and SQLite
(medium.com)
5 points
by
sktrdie
9y ago
|
1 comments
431.
▲
by
sktrdie
9y ago
There are benefits other than censorship resistance. For instance, these kind of sites are cheaper to run and are more resilient to DDoS attacks.
432.
▲
TorrentNet – Peer-To-peer Sites Using BitTorrent and SQLite
(medium.com)
8 points
by
sktrdie
9y ago
|
3 comments
433.
▲
by
sktrdie
9y ago
Considering there are companies such as GitHub and Microsoft (VSCode) behind Electron, I'm thinking they will eventually fix the memory/CPU footprint problem. In terms of programming and development I think it's great. Not to
434.
▲
by
sktrdie
10y ago
Exactly. The database syntax is the same. You're still writing SQL queries against the SQLite engine. I'm just replacing disk-access with network-piece-access. TorrentPeek goes one step further and puts this idea to use in sites,
435.
▲
by
sktrdie
10y ago
Right, and it's also HTML/CSS/JS for site owners to program interactions of their site using SQL queries that are prioritized against the underlying torrent. Imagine sharing wikipedia dumps, along with an index.html page. Tor
436.
▲
by
sktrdie
10y ago
No you don't need to download the indexes beforehand. The download always starts from the first piece/page (0). From there it essentially performs binary search and only downloads the least amount of pieces possible in order to sa
437.
▲
by
sktrdie
10y ago
You mean when the database is well indexed? Yes. SQLite supports Full Text Search ( https://sqlite.org/fts5.html ) which builds all the indexes for you, allowing you to perform search-engine-like functionality. But you'r
438.
▲
by
sktrdie
10y ago
Indeed. Without indexes it would be quite silly. SQLite supports Full Text Search (and so does TorrentPeek), so results get back after about ~20 pieces are read.
439.
▲
by
sktrdie
10y ago
Yes. I ran real world numbers. Before getting a result you still have to download on average ~20 pieces (32KB * 20 = 640KB). With healthy swarms and a 500kb/s connection you should get results as soon as ~1 second.
440.
▲
by
sktrdie
10y ago
Actually 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 tech
441.
▲
by
sktrdie
10y ago
The main reason that there are no binaries for Windows/Linux it's because I don't have these machines to compile the project against. I will eventually create binaries for all platforms. Letting it compile by node (node-gyp)
442.
▲
by
sktrdie
10y ago
Yep. The SQLite database can virtually contain anything. TorrentPeek is about sites, but there's nothing stopping you from using it to store information about software packages.
443.
▲
by
sktrdie
10y ago
Yes sorry about that. The project is still an experiment, mostly used to get real world numbers on the feasibility of the idea. I intend to maintain it and develop it much further so I will definitely clean it up.
444.
▲
by
sktrdie
10y ago
Author here. Yes the SQLite engine returns an SQLITE_OK value when the query is complete, just like if it were a database file on disk. The insight here is that we can tell SQLite (via VFS) to talk torrent-pieces rather than disk-pages, so
445.
▲
Show HN: TorrentPeek – Distributed search engines using BitTorrent and SQLite
(github.com)
184 points
by
sktrdie
10y ago
|
33 comments
446.
▲
by
sktrdie
10y ago
Author here. I see potential for this specifically if combined with BEP46 ( http://www.bittorrent.org/beps/bep_0046.html ). Essentially, if we can update torrents via DHT mutable items, we can have distributed sites - si
447.
▲
TorrentPeek – Query inside torrents without downloading them entirely
(github.com)
3 points
by
sktrdie
10y ago
|
1 comments
448.
▲
by
sktrdie
10y ago
You can do all the C++ fast stuff you want on the server.
449.
▲
by
sktrdie
10y ago
If you like Node.js and HTML/CSS, just have a node daemon running in the background with an HTTP server to your app! It's just like Electron, but without the CPU/RAM/Battery usage. You can even have binaries that stay op
450.
▲
by
sktrdie
10y ago
Why not just have a daemon process that runs a site on HTTP or WebSocket so you can use the app in your browser? I've seen apps that run with a double-click, stay open, and open my browser tab on 127.0.0.1:43110, with the entire app ri
More ›