HNHacker News
TopNewBestAskShowJobs

misterdata

1,231 karma · joined May 27, 2013

Partner at Dialogic (https://dialogic.nl) specialized in digitization, cybersecurity and AI in the public sector. Personal website over at https://t-shaped.nl.

[ my public key: https://keybase.io/tommyv; my proof: https://keybase.io/tommyv/sigs/5iSpz18mhGRCuuY9rj_F8cBvIJwchhZmJ-GJuiaJKt8 ]

submissionscomments
misterdata··on Daisy: A private blockchain where blocks are SQLite databases, in Go
See https://github.com/pixelspark/catena - does exactly this.
misterdata··on Show HN: An SQL database on top of a blockchain
I think it is actually a good idea to describe the whole point of using a blockchain as suggested. A lot of organisations I encounter don't really have a clue and do not realize that even a traditional database could fill their need perfectly in many cases.
misterdata··on Show HN: An SQL database on top of a blockchain
Could be anything that you could also use Ethereum for. This provides similar functionality, only with a more familiar (SQL) interface.

Some things I thought of: governmental registries, tracking history of physical assets (e.g. tracking of maintenance history of aerospace components), software licensing, storing timestamped cargo manifests (like the Maersk case). You could even build a currency on this with the right set of privileges.

misterdata··on Daisy: A private blockchain where blocks are SQLite databases, in Go
Why store a database file in each block when you could also store transactions? This is what Catena does: https://news.ycombinator.com/item?id=14548174. Also allows for some interesting things you can do with privileges, for instance.
misterdata··on Show HN: An SQL database on top of a blockchain
Yes, so what this does is timestamp transactions (in this case SQL DML) in a decentralized way between nodes that do not or cannot trust each other. All this while enforcing write permissions ('grants') that were agreed upon earlier.

The idea that some of these transactions store data is not any different from the idea that some transactions in Bitcoin add new coins to the system, or that some transactions in Ethereum create and store contracts (which are code and data).

Now of course you could, instead of storing the actual data and/or SQL, put data in a DHT and reference and timestamp that.

misterdata··on Show HN: An SQL database on top of a blockchain
Well, using a blockchain for timestamping alone is pretty much worthless if it's not connected to an application. Bitcoin, Ethereum and others don't use a blockchain just for timestamping either, but store all sorts of data in it (transactions in Bitcoin and even complete programs in Ethereum).

That said, this is obviously not meant to store large amounts of data. But you could quite easily build a currency on top of this (add a 'balances' table, and use grants to determine who can update what - a future version could even provide smart contracts through SQL stored procedures).

misterdata··on Show HN: An SQL database on top of a blockchain
Author here, happy to answer any questions. The implementation notes [1] may be of interest as well!

[1] https://github.com/pixelspark/catena/blob/master/Implementat...

misterdata··on Tad, a tabular data viewer
Just noticed the installer changes the file association for CSV's so they all open with Tad, without asking me first. Please do not do this.

Otherwise, nice app. How does it scale to larger CSV files? I have been working on something similar (https://warp.one) for Mac, which streams CSV files (apparently you use a SQLite database behind the scenes as cache?)

misterdata··on Show HN: FSQL – Search through your file system with SQL-esque queries
For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax.

[1] http://voidtools.com

misterdata··on Accidentally Stopping a Global Cyber Attack
More likely used during testing by the author itself?
misterdata··on Debian 9 not including support for UEFI Secure Boot
So when will Debian 9 be released anyway? I can't seem to find any planning on the Debian website...
misterdata··on Show HN: TorrentPeek – Distributed search engines using BitTorrent and SQLite
Without indexes, SQLite will do a table scan of sorts, which would still require all pages (=torrent pieces) that have data for a particular table. With indexes however this can be a lot smarter (client likely only needs a few pages from the index for a single query).
misterdata··on Show HN: TorrentPeek – Distributed search engines using BitTorrent and SQLite
It needs a few libraries (libtorrent, sqlite) which seem to be packaged as binaries for macOS only - build them anew for your platform and it will probably run.
misterdata··on Leaked NSA Malware Threatens Windows Users Around the World
Yes, but most NAT routers consumers use act as a firewall too (i.e. they block ingress traffic that is not related to a connection that was initiated from inside)
misterdata··on WebVR Experiments
Cool. Now we wait until someone builds this one: http://memory-alpha.wikia.com/wiki/The_Game_(episode)
misterdata··on Swift 3.1 Released
https://gist.github.com/pixelspark/f4f34a257d84611e7204b646d...

Real-world use: https://github.com/pixelspark/warp/blob/dcf57462bd400df6d067...

(the typealias thing is a bit weird here, I agree - it also doesn't crash without it. Nevertheless this compiled fine on 3.0 and should show a nice error, not require me to leave out every other file from the build to find out where it goes wrong, then bisect that file to find out which line causes it)

misterdata··on Swift 3.1 Released
Of course, just did. Very surprised that this happens for a 'source compatible' point release of Swift. Especially as this can be triggered with only five fairly simple lines of code. Not good.
misterdata··on Swift 3.1 Released
Just installed, compiling a fairly large project gives me "Command failed due to signal: Illegal instruction: 4" without any further information. Smooth...
misterdata··on Curl is C
This is ignoring the fact that sensitive data may actually be inside the (vulnerable, locked-down) process. Or checks inside the process may in some way be influenced (remember register_globals in PHP? This happens even when you execute PHP in a locked-down container).

A safe language greatly helps to prevent the sort of bug that compromises within-process security.

misterdata··on A solution for enabling UDP in the web
This is more or less what the sandbox mechanism on macOS does today. Unless a sandboxed app was given special entitlements from Apple, it can only access files that were brought into the sandbox at some point (for instance by selecting it in an 'open file' dialog, aka 'powerbox').
misterdata··on Odo: Shapeshifting for your data
Very nice! I have been working on a similar library in Swift [1] which does this, but also has a nice user interface on Mac and (soon) iOS [2]. Coincidentally also uses a Star Trek themed name :-)

[1] http://github.com/pixelspark/warp [2] https://warp.one

misterdata··on IBM says Swift is ready for the enterprise
The Dock? Why would they completely rewrite the Dock?
misterdata··on Object Spreadsheets
Ah yes, sorry!
misterdata··on Object Spreadsheets
See also https://warp.one for a similar tool on Mac
misterdata··on Why is printing “B” dramatically slower than printing “#”? (2014)
That was my first thought too, but I expect glyphs will probably be cached for a while after being rendered, which should make any difference in rendering speed negligible.
misterdata··on You Suck at Excel with Joel Spolsky (2015) [video]
Sex
misterdata··on Warp: convert and analyze data sets at light speed on Mac (just open sourced)
Author here - so glad to finally have decided to put nearly two years of work out in the open. Happy to answer any questions!
misterdata··on Decoding Data from Iridium Satellites
The doppler shfit also supposedly provided a clue about the whereabouts of MH370 after it disappeared: https://theaviationist.com/2014/03/27/inmarsat-helps-finding...
misterdata··on Does a compiler use all x86 instructions? (2010)
https://github.com/xoreaxeaxeax/movfuscator
misterdata··on A x64 OS #1: UEFI
Why? Most of the older environments can be perfectly replicated in virtualized form...
← PreviousPage 4 of 6Next →