HNHacker News
TopNewBestAskShowJobs

bobivl

57 karma · joined May 28, 2016

submissionscomments
bobivl··on Keylogger leaks data via Apple AirTag network
There is a longer article [1] describing the attack, but it is in German and behind a paywall.

[1] https://www.heise.de/hintergrund/c-t-deckt-auf-Keylogger-nut...

bobivl··on Apple Vision Pro: Apple’s first spatial computer
To replace a laptop (for me), I need to be able to type. It does not look easily possible from what I have seen, but missed the first part.
bobivl··on Multimodal GPT-4 to be released next week
That is exactly what happened, I wanted to share the original article and did not see that they also have an english version (because they usually do not have one).
bobivl··on Multimodal GPT-4 to be released next week
English version here: https://www.heise.de/news/GPT-4-is-coming-next-week-and-it-w...
bobivl··on Q – Run SQL Directly on CSV or TSV Files
Cut, sort, join and awk can be pretty powerful and fast. If it becomes too tedious to manually write them, you can also use BigBash [1] to convert a SQL query automatically to a one-liner that only use these tools to execute the query.

[1] http://bigbash.it

bobivl··on TextQL: Execute SQL Against CSV or TSV
There is also BigBash [0] that converts an Sql statement to a bash one-liner (using sed, grep, awk,...) which can then run to execute the query. The advantage is that you can let it run on very large file(s) because of the streaming nature of linus bintools.

[0] http://bigbash.it or the corresponding Github repo.

bobivl··on Data Science at the Command Line
I also used bash scripts a lot to get quick insights from csv files. Someday I realized that these are mostly sql queries that I encoded into complex scripts. For the sake of trying, I implemented a simple sql to bash transpiler that takes a sql query and returns a bash one-liner that you can execute on csv file(s).

Give it a try: http://bigbash.it

bobivl··on Command-line tools can be faster than a Hadoop cluster (2014)
If you like to do data analyses in bash, you might also enjoy bigbash[1]. This tool generates quite performant bash one-liners from SQL Select statements that easily crunch GB of csv data.

Disclaimer: I am the main author.

[1] http://bigbash.it

bobivl··on Show HN: Bigbash – Generate bash one-liners from SQL queries on files without DB
Java is only necessary for the "compilation" of the query. The resulting bash script uses only standard unix tools and runs without java.