News for hackers. Stuff that matters.

bobivl

Re:Keylogger leaks data via Apple AirTag network on Saturday November 04, 2023 @08:54AM (#38140612)
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...

Re:Apple Vision Pro: Apple’s first spatial computer on Monday June 05, 2023 @03:17PM (#36201936)
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.
Re:Multimodal GPT-4 to be released next week on Thursday March 09, 2023 @04:10PM (#35086771)
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).
Re:Q – Run SQL Directly on CSV or TSV Files on Wednesday September 21, 2022 @02:45PM (#32929547)
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

Re:TextQL: Execute SQL Against CSV or TSV on Sunday April 08, 2018 @02:43AM (#16784956)
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.

Re:Data Science at the Command Line on Saturday January 27, 2018 @06:13PM (#16248655)
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

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

Java is only necessary for the "compilation" of the query. The resulting bash script uses only standard unix tools and runs without java.