summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMisha Brukman <mbrukman@google.com>2019-01-06 14:26:37 -0500
committerMisha Brukman <mbrukman@google.com>2019-01-06 17:03:09 -0500
commit0719c6f35fd1c8e4abc80303e896b41775ceca6a (patch)
tree902e612ee3f50ff75020295cb7dcc1d1ce8a1162
parent28f776ed464c8c125995485cf40f037128354061 (diff)
Replace image code samples with text.
This enables easy copy-pasting of sample code. Also added code formatting for SQL keywords.
-rw-r--r--README.markdown8
-rw-r--r--doc/basic-examples.pngbin6635 -> 0 bytes
2 files changed, 6 insertions, 2 deletions
diff --git a/README.markdown b/README.markdown
index 85863af..9477de3 100644
--- a/README.markdown
+++ b/README.markdown
@@ -3,7 +3,7 @@
# q - Text as Data
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).
-q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings.
+q treats ordinary files as database tables, and supports all SQL constructs, such as `WHERE`, `GROUP BY`, `JOIN`s, etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings.
q's web site is [http://harelba.github.io/q/](http://harelba.github.io/q/). It contains everything you need to download and use q immediately.
@@ -14,7 +14,11 @@ Instructions for all OSs are [here](http://harelba.github.io/q/install.html).
## Examples
-![blah](doc/basic-examples.png)
+```
+q "SELECT COUNT(*) FROM ./clicks_file.csv WHERE c3 > 32.3"
+
+ps -ef | q -H "SELECT UID, COUNT(*) cnt FROM - GROUP BY UID ORDER BY cnt DESC LIMIT 3"
+```
Go [here](http://harelba.github.io/q/examples.html) for more examples.
diff --git a/doc/basic-examples.png b/doc/basic-examples.png
deleted file mode 100644
index 6943d47..0000000
--- a/doc/basic-examples.png
+++ /dev/null
Binary files differ