Getting rid of the sqlite3 gem (for shoes4) · Issue #159 · hacketyhack/hacketyhack · GitHub
Skip to content

Getting rid of the sqlite3 gem (for shoes4) #159

Open

Description

@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?

Activity

  1. plexus commented on Apr 25, 2013

    @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
    .

  2. steveklabnik commented on Apr 25, 2013

    @steveklabnik
    Member

    Don't you just use jdbc-sqlite3?

  3. PragTob commented on Jun 28, 2013

    @PragTob
    MemberAuthor

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions