search

rowland / fb

Firebird Extension Library for Ruby
64 stars 36 forks source link

Make it work with fb embedded... #17

Closed ramsees closed 9 years ago

ramsees commented 12 years ago

There is no option to use fb embedded, it would be good to have that option for many reasons.

rowland commented 12 years ago

Ideally, you would be able to switch at runtime, but making that happen would be non-trivial since the way Ruby native extensions work the shared library is selected at compile time.

It may be possible to build two separate gems by replacing "fbclient" with "fbembed" in extconf.rb, but I haven't tried this.

ramsees commented 12 years ago

That would be great, specially since hosting solution often doesn't offer Firebird installed.

rowland commented 12 years ago

One would have to limit a hosted application to a single instance with embedded Firebird, since the process takes exclusive control of the database.

ramsees commented 12 years ago

I'm aware of that, but is the only option I hace due to the poor Firebird support from the hosting options, this is something I've done with ASP.net, now, I think the multi-instace access is contemplated for the next Fb release.

ramsees commented 12 years ago

Other usage is to have a local database in your application as cache, since firebird allow to easily change from a server database to an embedded one I often use an ambedded fb for local caches in my applications, the application still connects to the server database, but also has a local cache in the client to work disconnected.

nurettin commented 10 years ago

This would make a great sqlite alternative

mariuz commented 10 years ago

It might be possible to do late binding like we do in ibpp In the followng thread "libfbembed and Debian/Ubuntu Builds" there is a patch for inspiration

http://permalink.gmane.org/gmane.comp.db.firebird.devel/4743

and the disscussion on ibpp list http://sourceforge.net/p/ibpp/mailman/message/32147078/