sqlite3-ruby compilation and sqlite3 packaging for a rails app

Question

we are currently trying to package sqlite3 and sqlite3-ruby with an application that will be released as open source (ruby/rails based) i am evaluating if it is possible to package sqlite3-ruby for windows/linux and mac.

my thoughts were, to download sqlite3-amalgamation, sqlite3-ruby on all the platforms and then compile on each. here are my questions/ current problems:

1. the docs of sqlite3-ruby ( see http://github.com/luislavena/sqlite3-ruby ) "Install SQLite3, enabling option SQLITE_ENABLE_COLUMN_METADATA (see www.sqlite.org/compile.html for details)." where do i put this? in the makefile? any pointers or an example would be really helpful!

2. compiling sqlite3-ruby with the current sqlite3 sqlite3-ruby seems to search for sqlite.h, unfortunately the current sqlite3 seems to only provide "sqlite3.h" -- what am i doing wrong here?

are my thoughts/steps on compiling sqlite3-ruby wrong, maybe?

1. download amalgamation from sqlite.org
2. compile to a custom dir
3. change install.rb (line 11) to unless system( "ruby extconf.rb --with-sqlite-dir=/my/custom_dir" )

any pointers or help very welcome!

Answer 1

re: windows you can just use the windows precompiled binary gem.