Jonathan Andrew Wolter jawspeak

## things_app_sqlite_reverse_engineered_schema.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jawspeak
                / things_app_sqlite_reverse_engineered_schema.md
            
            
              Last active
              August 29, 2015 14:26
                — forked from RaVbaker/readme.md
            
              
                Reverse engineering Things SQLite tasks database
              
          
    To open SQLite Things.app database run this command in Terminal.app:
$ sqlite3 ~/Library/Containers/com.culturedcode.things/Data/Library/Application\ Support/Cultured\ Code/Things/ThingsLibrary.db

In SQLite command-line type this query to get your tasks stats:
sqlite> .mode column
sqlite> .header on
sqlite> select zscheduler, zstatus, ztrashed, count(*) from ZTHING where z_ent = 13 group by  zstatus,ztrashed order by Z_pk desc;

ZSCHEDULER ZSTATUS ZTRASHED count(*)

  
## upgrade server ree 1.8.7 to ruby 1.9.3.sh
# prereqs
  sudo apt-get update
  sudo /usr/bin/apt-get install build-essential openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion pkg-config

# multiuser rvm
$ \curl -L https://get.rvm.io | sudo bash -s stable --ruby=ruby-1.9.3-p362
# add user to rvm group
sudo usermod -a -G rvm ubuntu
$ logout and log back in

## mysql_db_and_table_size_queries.sql
-- Check the total size of each database
SELECT
  tables.TABLE_SCHEMA AS database_name,
  ROUND(SUM(tables.DATA_LENGTH + tables.INDEX_LENGTH) / POWER(2, 30), 3) AS database_size_in_gb
FROM information_schema.TABLES AS tables
GROUP BY tables.TABLE_SCHEMA
ORDER BY database_size_in_gb DESC;

-- List all tables larger than 1 GB
SELECT

## c10k-test-client.c
// HTTP client for testing high connection concurrency
// Authors: Richard Jones and Rasmus Andersson
// Released in the public domain. No restrictions, no support.

// SEE:
// http://rsms.me/2009/10/05/10k-comet-connections.html

#include <sys/types.h>
#include <sys/time.h>
#include <sys/queue.h>
	# prereqs
	sudo apt-get update
	sudo /usr/bin/apt-get install build-essential openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion pkg-config

	# multiuser rvm
	$ \curl -L https://get.rvm.io \| sudo bash -s stable --ruby=ruby-1.9.3-p362
	# add user to rvm group
	sudo usermod -a -G rvm ubuntu
	$ logout and log back in
	-- Check the total size of each database
	SELECT
	tables.TABLE_SCHEMA AS database_name,
	ROUND(SUM(tables.DATA_LENGTH + tables.INDEX_LENGTH) / POWER(2, 30), 3) AS database_size_in_gb
	FROM information_schema.TABLES AS tables
	GROUP BY tables.TABLE_SCHEMA
	ORDER BY database_size_in_gb DESC;

	-- List all tables larger than 1 GB
	SELECT
	// HTTP client for testing high connection concurrency
	// Authors: Richard Jones and Rasmus Andersson
	// Released in the public domain. No restrictions, no support.

	// SEE:
	// http://rsms.me/2009/10/05/10k-comet-connections.html

	#include <sys/types.h>
	#include <sys/time.h>
	#include <sys/queue.h>