Assuming you only plan on using ASCII encoding, a very viable option may be to use the Trigram (pg_trgm) module: http://www.postgresql.org/docs/9.0/interactive/pgtrgm.html (more…)
Archive for the ‘Database’ Category
Partial Word Search / Spell Check in PostgreSQL 9 using Trigram (trgm)
Thursday, February 16th, 2012Full Text Search (FTS) in PostgreSQL 9.1 (Examples Included)
Monday, January 16th, 2012This post is aimed at providing only the information necessary to rapidly understand and deploy Full Text Search into your PostgreSQL environment. For more documentation, I’d recommend checking out the following URLs:
- http://linuxgazette.net/164/sephton.html
- http://www.postgresql.org/docs/9.1/static/textsearch.html
- http://www.slideshare.net/billkarwin/full-text-search-in-postgresql
Working with the hstore data type in PostgreSQL 9.0 / 9.1
Wednesday, November 30th, 2011This is a quick reference on how to install the HSTORE contrib module into your PostgreSQL database as well as a few example queries explaining how to interface with and query the HSTORE data type. (more…)
PostgreSQL and ODBC in 64-Bit Windows
Tuesday, September 20th, 2011(This document has been modified to instruct the setup of not only 64-bit systems, but 32-bit set ups as well.)
This tutorial is for individuals who are interested in setting up a DSN entry in their Data Sources (ODBC) for PostgreSQL. We cover both 32-bit and 64-bit versions of Windows, as each must be configured slightly differently.
(more…)
Python and PostgreSQL: A Quick Reference to psycopg2
Thursday, March 31st, 2011As with most database technologies I interact with, I like to throw together a few simple examples as reminders on how to interface with that technology. In this case we’re interfacing with the PostgreSQL database through the Python programming language. (more…)
Python and MongoDB: A Quick Reference to PyMongo
Tuesday, December 28th, 2010A constant frustration of mine is working with a library which is poorly documented and doesn’t contain useful examples.
As such, I have put together the following quick reference working with the PyMongo library for interactions between Python and the MongoDB storage facility.
(more…)
MongoDB With PHP Quick Reference
Thursday, October 14th, 2010I have compiled a quick reference guide for newbies to interacting with MongoDB through PHP. Please feel free to add your own examples in the comments below. (more…)
Database Barrage
Thursday, October 14th, 2010Something which has always boggled me is the use of string-based queries. We all know strings take up a lot of space, they require a lot of processing power to interpret into computer understandable information, and is an all in all bad way of transferring information. Another example of a horrible method with equally horrible implications is that of XML. Yet some how it is exactly these principles which has driven the success of SQL-type databases for years! It can only be assumed that this success is not due to the great philosophy of using string-based queries, but is instead one of ignorance and overall complacence on the end of developers and users like myself. (more…)
PostgreSQL Quick Reference
Saturday, May 29th, 2010For those transitioning from other SQL database engines such as MSSQL or mySQL, I have put together this very simple quick reference for the most common of tasks.
(more…)