> March, 2010 - Vinova - Page 2

Merging Lucene and Solr

Personally, I feel that this merge is a good thing for both Lucene and Solr: Solr users get the latest Lucene improvements faster and releases get streamlined. Lucene users get access to Solr features such as faceting. The in-sync trunk allows new features to make their way into the right place (Lucene vs Solr) more easily and duplication is minimized. Bugs are caught earlier by the huge combined test suite. More number of committers means more ideas and hands available to the projects Other Lucene based projects can benefit too because many Solr features will be made available through Java APIs. There are a couple of things to be worked out. For example, we need to decide where the integrated sources should live and whether or not to sync Solr’s version with Lucene’s. All this will take some time but I am confident that our combined community will manage the transition well. via shal.in What’s a good news. Solr have been provided Enterprise Level support by lucidimagination.com. Big corporates using Solr: AOL, Comcast Interactive Media, IBM, Netflix, LinkedIn and MySpace. I believe that the future of Solr is...

Using ActiveRecord to access Microsoft SQL Server via ODBC

Recently I need to insert 400+ rows of data into an eight year old MSSQL 2000 and MSSQL 2008 database. It’s really a pain in the ass if I have to do it by hand or learning a new tool to do it. Luckily, I can use ActiveRecord to do that easily thanks to activerecord-sqlserver-adapter and and auto table field mapping of ActiveRecord. Here is a quick step-by-step guide: Install Ruby on Windows machine (that run SQL server). Download One-Click Ruby Installer for Windows for Ruby 1.8.6 P26 at http://rubyforge.org/frs/download.php/29263/ruby186-26.exe And install it. If you use the default setting, it will setup ruby at c:ruby folder with rubygem 0.9.3 Update RubyGems Open “Command Prompt” cd c:rubybin gem update –system Install ActiveRecord with SQLServer Adapter gem install activerecord-sqlserver-adapter –source=http://gems.rubyonrails.org If the installation result is: Successfully installed activesupport-2.2.2 Successfully installed activerecord-2.2.2 Successfully installed activerecord-sqlserver-adapter-1.0.0.9250 3 gems installed Create a DSN (Data Source Name) Luckily I can reuse DNS from current ASP project so I don’t need to create new one. If you have to, you can follow guideline in [1]. Setup connection and create property ActiveRecord based classes require “active_record” ActiveRecord::Base.establish_connection( :adapter => “sqlserver”, :mode => “odbc”, :username => “yourusername”, :password => “yourpassword”, :dsn => “yourDSN” ) class AnyNameYouWant < ActiveRecord::Base set_table_name “TableNeedToAccess” set_primary_key “PrimaryID” end Start irb by: cd c:rubybin irb And paste above chuck of code in to irb. From now, you can use ActiveRecord based classes to read/write/add/remove SQL Server table as in a Rails script/console environment. I also got a problem with Time.mktime and need to some code adjust by hand Open c:rubylibrubygems1.8gemsactiverecord-sqlserver-adapter-1.0.0.9250libactive_recordconnection_adapterssqlserver_adapter.rb Replace “Time.mktime” by “Datetime.new”...

Teamwork

Teamwork is the capability to comprehend and recognize the diverse strengths and abilities in a group setting and then applying them to one final solution. Working as a team makes it easier to accomplish goals, some things cannot be accomplished by people working individually – From...

Backuping and restoring a single table using mysqldump

mysqldump can retrieve and dump table contents row by row, or it can retrieve the entire content from a table and buffer it in memory before dumping it. Buffering in memory can be a problem if you are dumping large tables. To dump tables row by row, use the –quick option (or –opt, which enables –quick). The –opt option (and hence –quick) is enabled by default, so to enable memory buffering, use –skip-quick. Backuping a single table from a database mysqldump -u -p database_one table_name > /var/www/backups/table_name.sql Restoring the table into another database mysql -u -p database_two <...
Malcare WordPress Security

singapore website design,design firms in singapore,singapore web development,singapore app developer,mobile app development singapore,website development singapore,web design singapore,mobile application developer singapore,android developer singapore,singapore web design,ruby on rails developer singapore,mobile apps singapore,web development company singapore,singapore web design services,app development singapore,ios app development singapore,website design singapore,app developer singapore,website designer singapore,web application singapore,web design company singapore,singapore mobile application developer,web designer singapore,website developer singapore,ios developer singapore,mobile app developer singapore,mobile game developer singapore,singapore mobile app developer,mobile developer singapore,developers in singapore,web design services singapore,graphic designer in singapore,design agency singapore,web development singapore,mobile application development singapore,developer in singapore,mobile apps development singapore