Jun 12 2012
Data insertion to CouchDB using Lightcouch lib in Java (Sample)
Introduction
Hello, a small sample on how to insert JSON data to couchDB.
First off there are MANY java libraries for accessing couchdb. For information on which one to choose for you the 2 links below may help:
1) http://stackoverflow.com/questions/1105807/which-java-library-libraries-for-couchdb
2) http://wiki.apache.org/couchdb/Getting_started_with_Java
In this post we made use of LightCouch as we wanted something relatively simple without object mappings and other such features.
Aside: an also interesting tutorial utilizing couchdb4j with description of sessions is: http://www.drdobbs.com/jvm/223100116
Sep 29 2012
How to search all columns of all tables in a microsoft sql database for a keyword (including any data type)
Hey,
I’ve been working on a very large unknown database (over 45 tables) where the reverse engineered schema diagram was quite chaotic. Having the task to find several needles in the haystack I searched the internet and found the very useful script at:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm (pasted below).
However, one limitation I noticed was that the script only searched (‘char’, ‘varchar’, ‘nchar’, ‘nvarchar’).
By Menelaos Bakopoulos • Programming, Scripts 0 • Tags: Database, SQL, Stored Procedure