https://github.com/kshvmdn/fsql
Search files under any directory with SQL-like syntax. Useful stuff.
fsql
Forum rules
General talk about software - if the program is not in the repos, please links to the developer's page or github.
General talk about software - if the program is not in the repos, please links to the developer's page or github.
- franksinistra
- Ivana Fukalot
- Posts: 1093
- Joined: Mon Jan 27, 2014 2:03 am
- Location: 印尼国
fsql
rice no more.
- wuxmedia
- Grasshopper
- Posts: 6447
- Joined: Wed Oct 17, 2012 11:32 am
- Location: Back in Blighty
- Contact:
Re: fsql
OMG I might even get good at SQL...
what happens if one types drop tables? and how about... oh it's only search...
how about putting fucking grep into the mysql command line, that'd be good.... i suppose do a mysql command on the bash shell and grep it.
what happens if one types drop tables? and how about... oh it's only search...
how about putting fucking grep into the mysql command line, that'd be good.... i suppose do a mysql command on the bash shell and grep it.
- franksinistra
- Ivana Fukalot
- Posts: 1093
- Joined: Mon Jan 27, 2014 2:03 am
- Location: 印尼国
Re: fsql
exactly how i feel......how about putting fucking grep into the mysql command line
rice no more.
- wuxmedia
- Grasshopper
- Posts: 6447
- Joined: Wed Oct 17, 2012 11:32 am
- Location: Back in Blighty
- Contact:
Re: fsql
^ yes- although I was pleased to see Ctrl -r works as expected (searches previous commands) :D
my solution is to run in tmux (all the servers are) and hit copy mode and do a search from there. works piped to grep, but what a mouthful...
this is the other way someone showed me at work:
to find table, then:
to narrow it down
my solution is to run in tmux (all the servers are) and hit copy mode and do a search from there.
Code: Select all
mysql --user="$user" --password="$password" --database="$user" --execute='select * in wp_posts;'
this is the other way someone showed me at work:
Code: Select all
rgrep -l "searchterm" /var/lib/mysql/user/*
Code: Select all
strings wp_options.* | grep <searchterm>
- franksinistra
- Ivana Fukalot
- Posts: 1093
- Joined: Mon Jan 27, 2014 2:03 am
- Location: 印尼国
Re: fsql
^ I used to do mysqldump to /tmp and grep from there, works pretty nice until a co-worker made a nice ORM wrapper for it.
rice no more.