| 01:00.37 | *** part/#qi-hardware rozzin (23963ea3bf@feep.hackerposse.com) |
| 01:00.39 | *** join/#qi-hardware rozzin (23963ea3bf@feep.hackerposse.com) |
| 01:20.24 | *** join/#qi-hardware infobot (ibot@208.53.50.136) |
| 01:20.24 | *** topic/#qi-hardware is Copyleft hardware - http://qi-hardware.com | hardware hackers join here to discuss Ben NanoNote, atben/atusb 802.15.4 wireless, anelok and other community driven hw projects | public logging at http://en.qi-hardware.com/irclogs and http://irclog.whitequark.org/qi-hardware |
| 01:20.24 | *** mode/#qi-hardware [+v infobot] by ChanServ |
| 04:17.51 | *** join/#qi-hardware eightdot (~eightdot@customer-212-084-140-031.solcon.nl) |
| 05:59.46 | *** join/#qi-hardware qi-bot (~qi-bot@turandot.qi-hardware.com) |
| 05:59.46 | *** mode/#qi-hardware [+o qi-bot] by ChanServ |
| 06:00.10 | *** join/#qi-hardware eintopf (~eintopf@unaffiliated/eintopf) |
| 06:00.45 | *** join/#qi-hardware incomprehensibly (sid3405@gateway/web/irccloud.com/x-qelamtszdqypnvnr) |
| 14:16.42 | *** join/#qi-hardware jwhitmore (~jwhitmore@host86-137-166-5.range86-137.btcentralplus.com) |
| 14:34.02 | xentrac | kyak: "look" is a database index lookup tool |
| 14:34.58 | xentrac | look traditionally does a binary search on file offsets, so you can apply it to files much larger than memory. GNU look doesn't do that by default but does have an option to do so |
| 14:38.22 | xentrac | between look, sort, join, comm, and potentially awk to rearrange fields if join -o isn't sufficiently convenient, you can do quite a bit of ad-hoc relational database stuff in the Unix shell |
| 14:39.01 | xentrac | even without the various demon spawn of dbm |
| 14:39.50 | kyak | so, stuff you can do in sqlite nowadays :) |
| 14:40.05 | xentrac | yes, and you probably should in many cases |
| 14:40.05 | kyak | but it's interesting, still |
| 14:40.35 | xentrac | but you don't get a query optimizer, you don't get automatic index updates (make is not really adequate to that task), and you don't get a screen forms editor for data entry and QBE |
| 14:40.51 | xentrac | I mean with the shell |
| 14:40.57 | xentrac | SQLite has a pretty decent query optimizer |
| 14:41.38 | xentrac | and of course it updates its indices properly |
| 14:41.59 | xentrac | at Satellogic we couldn't use SQLite though |
| 14:42.15 | xentrac | it didn't deal gracefully with filesystem corruption |
| 14:42.43 | xentrac | we used Postgres on the ground and a filesystem directory with JSON files on the satellites |
| 15:04.44 | *** join/#qi-hardware jwhitmore (~jwhitmore@host86-137-166-5.range86-137.btcentralplus.com) |