Getting rid of the sqlite3 gem (for shoes4)

[PragTob]

In the future, hacketyhack shall work with shoes4. That's what we are working for.

However currently it uses the sqlite3 gem in `lib/database.rb', which is a problem because it needs c-extensions. That is a problem as jruby cut c-extension support.

From a first look it should be easy to replace sqlite with something else, I'd say Pstore or YAML::Store as the interface is tiny and well defined.

We would just have a problem with the migration of old user data. We could also use a jruby gem for sqlite3, if there is one. However, I'd much rather use the simple file based standard library functionality as mentioned above.

Thoughts?

[plexus]

At first glance there's no sqlite3 ffi gem, although some people have
worked on porting it.

Less dependencies is better though so I think it's a good idea, but there
would have to be a conversion script as well.
On Apr 24, 2013 11:50 PM, "Tobias Pfeiffer" notifications@github.com
wrote:

In the future, hacketyhack shall work with shoes4. That's what we are
working for.

However currently it uses the sqlite3 gem in `lib/database.rb', which is a
problem because it needs c-extensions. That is a problem as jruby cut
c-extension support.

From a first look it should be easy to replace sqlite with something else,
I'd say Pstore or YAML::Store as the interface is tiny and well defined.

We would just have a problem with the migration of old user data. We could
also use a jruby gem for sqlite3, if there is one. However, I'd much rather
use the simple file based standard library functionality as mentioned above.

Thoughts?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/159
.

[steveklabnik]

Don't you just use jdbc-sqlite3?

[PragTob]

Just a note, that we basically have Steve's ok on this :-D