sqlite: add, sqlite3 configuration file

diff --git a/.gitignore b/.gitignore
index 699bf22e59e0789399c5729a906fe13a652b0d11..a0d0192f2da3cbc787bfb563815b77ccf7f17000 100644 (file)
--- a/.gitignore
+++ b/.gitignore
@@ -2,3 +2,4 @@
 /ghc/x86_64-linux-*/
 /lftp/rl_history
 /maxima/maxout.gnuplot_pipes
+/sqlite/sqliterc

diff --git a/setup.sh b/setup.sh
index d80d1cc872af30b33f90277f42c7fde1c5fd8095..43ad66f5e5d3255735bc4cbc16eeb861d06a6f2e 100755 (executable)
--- a/setup.sh
+++ b/setup.sh
@@ -49,6 +49,12 @@ if installed mysql; then
     link mysql/my.cnf ~/.my.cnf
 fi
 
+if installed sqlite3; then
+    # sqlite3 doesn't support any comments in sqliterc.
+    grep -v -E '^#' sqlite/sqliterc.in >sqlite/sqliterc
+    link sqlite/sqliterc ~/.sqliterc
+fi
+
 # perlcritic to check Perl programs for common problems.
 if installed perlcritic; then
     link perl/perlcriticrc ~/.perlcriticrc

diff --git a/sqlite/sqliterc.in b/sqlite/sqliterc.in
new file mode 100644 (file)
index 0000000..f8bfa58
--- /dev/null
+++ b/sqlite/sqliterc.in
@@ -0,0 +1,28 @@
+# sqlite3 configuration file.
+#
+# sqlite3 doesn't support comments in ~/.sqliterc. They must be stripped
+# before using this file.
+
+# Copyright (C) 2014  Simon Ruderich
+#
+# This file is free software: you can redistribute it and/or modify
+# it under the terms of the GNU General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# This file is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this file.  If not, see <http://www.gnu.org/licenses/>.
+
+
+# Enable column output mode with headers. Used for SELECT statements and makes
+# them more readable.
+.mode column
+.headers on
+
+# Display NULL value as "NULL".
+.nullvalue NULL