Justin Clift
Justin Clift
On the backblaze data releases page here: https://db4s-beta.dbhub.io/releases/justinclift/backblaze-drive_stats.db ... there is a release named "2013 & 2014 data". Clicking on that name (it's a link), gives this error:...
Also pointed out by @danfowler, [Open Knowledge International](https://okfn.org/about/) seems fairly well aligned with what DBHub.io will provide. They have an initiative called "Frictionless Data", whose purpose is seamless data exchange....
For the front page, would some form of category browser like this make sense?  http://www.johnsnowlabs.com/healthcare-turnkey-data-science-operations/#services Theirs turns out to be non-functional... eg mousing...
It turns out Bootstrap (which we already use) includes better arrows to indicate sorting than what we're presently using for the database view page: https://getbootstrap.com/docs/3.3/components/ A decent example...
A recently user uploaded public database is being *extremely* slow to access through the webUI: https://db4s-beta.dbhub.io/AnsenIO/siren Even re-viewing columns which should clearly be in Memcached is extremely slow...
At some point we should investigate whether running `[PRAGMA optimize](http://sqlite.org/pragma.html#pragma_optimize)` is worthwhile on databases, after we've done the automatic index addition to them. Not high on the priority list though....
As a thought for the future, should we create some kind of shell command for interacting we the DBHub.io server remotely? eg create branches, push/pull/sync databases, etc?
An error on the dev1 console shows someone uploaded a database with a space in it's table name. The upload succeeded, but the database table can't be viewed as our...
Go has built in capabilities for writing unit tests, which we should start putting to use in a few weeks (?) once things are a bit further along. We could...
After looking through this DefCon presentation, I'm thinking server-side we'll likely need to write a much more in depth validator for SQLite database uploads: * https://www.blackhat.com/docs/us-17/wednesday/us-17-Feng-Many-Birds-One-Stone-Exploiting-A-Single-SQLite-Vulnerability-Across-Multiple-Software.pdf At present, our validator...