Blog
lucene solr 4: up and running
20 Oct, 14

lucene solr 4: up and running

by | Oct 20, 2014 | Uncategorized | Last updated at July 30, 2020

Solr: This is the Lucene based search api. Solr is open source enterprise search platform and written in Java, It provides the fast search with simple search, hit highlighting, faceted search, near real-time indexing, dynamic clustering, database integration, rich...
Date manipulation using SQL query
8 Sep, 14

Date manipulation using SQL query

by | Sep 8, 2014 | Database | Last updated at September 28, 2020

I have written some useful query. When you need some customization in date format and find some prior date using SQL then below query might be useful for you. Find prior/future date from the current/given date: SELECT now()::date + 2 AS date1, current_date -1 AS date2...