DB #42

DB #42 or how to choose technology :)

We have to implement a new feature. No matter what kind of feature it is. Well, we have to expose REST API, store and retrieve some dynamic data. We spent a lot of time choosing DB. The chief architect wanted MySql. Well, this idea have not pass our sanity filter. The data architect wanted AeroSpike, team leader suggested MongoDB that was blamed by DevOps that proposed Redis.

But as we all know the absolute answer to all questions is 42. So, we decided to choose the DB #42 from alphabetically sorted list of NoSQL databases. 

I opened Google and typed "list of nosql databases". Then I have chosen the following article. I had to extract a list of names of the databases and did it using the following command:

curl http://nosql-database.org/  | grep h3 | grep href > /tmp/db.hrefs.txt

(because all DB names in this list are surrounded by tag <a> with reference to their web page)

There was one case when 2 databases were written in one physical line and I fixed this manually. 

Then I ran the following command to get the alphabetical list of DB names:

cat /tmp/db.hrefs2.txt |  sed 's#</a>.*##' | sed 's/.*>//' | sort > /tmp/db.names.txt

The last phase it to print this list with attached numbers:

 i=1; cat /tmp/db.names.txt | while read l; do echo "$i,$l"; i=`expr $i + 1`; done

Here is the list:

1	Accumulo
2	acid-state
3	Aerospike
4	AlchemyDB
5	allegro-C
6	AllegroGraph
7	Amazon SimpleDB
8	AmisaDB:
9	Apache Flink
10	Applied Calculus
11	ArangoDB
12	ArangoDB
13	ArangoDB
14	Axibase
15	Azure DocumentDB
16	Azure Table Storage
17	BagriDB
18	BangDB
19	BaseX
20	BayesDB
21	BergDB
22	Berkeley DB
23	Berkeley DB XML
24	Bigdata
25	BinaryRage
26	BoltDB
27	BrightstarDB
28	BrightstarDB
29	Cachelot
30	Cassandra
31	Chordless
32	Chronicle Map
33	Cloudata
34	Cloud Datastore
35	Cloudera
36	Clusterpoint Server
37	CodernityDB
38	ConcourseDB
39	CoreObject
40	CortexDB
41	Couchbase Server
42	CouchDB
43	Crate Data
44	DaggerDB
45	Datomic
46	db4o
47	DBreeze
48	densodb
49	djondb
50	Druid
51	DynamoDB
52	Dynomite
53	EJDB
54	Elassandra
55	Elastic
56	Elliptics
57	EMC Documentum xDB
58	ESENT
59	Eventsourcing for Java (es4j)
60	Event Store
61	Execom IOG
62	eXist
63	eXtremeDB
64	eXtremeDB
65	eXtremeDB Financial Edition
66	EyeDB
67	Faircom C-Tree
68	Fallen 8
69	FileDB:
70	filejson
71	FlockDB
72	FoundationDB
73	FramerD
74	GemFire
75	GemStone/S
76	GenieDB
77	Genomu
78	GigaSpaces
79	Globals:
80	GPUdb
81	GraphBase
82	GridGain
83	GT.M
84	gunDB
85	gunDB
86	gunDB
87	Hadoop / HBase
88	Hazelcast
89	Hibari
90	HPCC
91	HSS Database
92	HyperDex
93	HyperGraphDB
94	Hypertable
95	IBM Cloudant
96	IBM Informix
97	IBM Lotus/Domino
98	iBoxDB
99	Infinispan
100	Infinite Graph
101	InfinityDB
102	influxdata
103	InfoGrid
104	Informix Time Series Solution
105	Intersystems Cache
106	ISIS Family
107	JADE
108	JasDB
109	jBASE
110	JEntigrator
111	JSON ODM
112	KAI
113	kdb+
114	KirbyBase
115	KitaroDB
116	KUDU
117	LevelDB
118	LightCloud
119	LSM
120	Magma
121	MapR
122	MarcelloDB
123	MarkLogic Server
124	Maxtable
125	MemcacheDB
126	MentDB:
127	Meronymy
128	MiniM DB
129	Mnesia
130	Model 204 Database
131	MonetDB
132	MongoDB
133	Moonshadow
134	Morantex
135	NCache
136	NDatabase
137	NeDB
138	NEO
139	Neo4J
140	nessDB
141	Newt DB
142	Ninja Database Pro
143	NosDB
144	NoSQL embedded db
145	ObjectDB
146	Objectivity
147	Onyx Database
148	OpenInsight
149	OpenLDAP
150	OpenLink Virtuoso
151	OpenQM
152	Oracle Coherence
153	Oracle NOSQL Database
154	OrientDB
155	OrientDB
156	Perst
157	PickleDB
158	PicoLisp
159	Pincaster
160	pipelinedb
161	Prevayler
162	Qizx
163	quasardb
164	Queplix
165	RaptorDB
166	RaptorDB
167	rasdaman
168	RavenDB
169	RDM Embedded
170	Reality
171	ReasonDB
172	Recutils:
173	Redis
174	RethinkDB
175	Riak
176	Riak TS
177	RockallDB
178	RocksDB
179	Scalaris
180	Scalien
181	SciDB
182	SCR Siemens Common Repository
183	Scylla
184	SDB
185	Sedna
186	SequoiaDB
187	Serenety
188	SharedHashFile
189	siaqodb
190	SisoDB
191	Sophia
192	Sparksee
193	Splice Machine
194	SpreadsheetDB
195	Starcounter
196	Sterling
197	STSdb
198	Symas LMDB
199	Tarantool/Box
200	TayzGrid
201	Terrastore
202	ThruDB
203	TIBCO Active Spaces
204	Tieto TRIP
205	TigerLogic PICK
206	TITAN
207	Tokutek:
208	Tokyo Cabinet / Tyrant
209	ToroDB
210	TreodeDB
211	Trinity
212	U2
213	upscaledb
214	VaultDB
215	VelocityDB
216	Versant
217	VertexDB
218	Voldemort
219	Vyhodb
220	weaver
221	WhiteDB
222	WonderDB
223	Yserial
224	ZODB

And the winner is .... CouchDB - number 42!

Conclusions

Every time you cannot agree which technology to choose just find the longest list of relevant technologies, sort them alphabetically and choose #42.