Desktop Database Application in Ruby


#1

Has anyone among the members made database application in Ruby? I want
to learn ruby and create a desktop database application like Point of
Sale, Inventory, Library management System etc wherein updates in 2 or
more tables is done, please helpby uploading your sample projects.Even
if it is not a complete database application as long as it shows how to
update 2 or more tables in a 1 to many or many to many realtionship in a
MYSQL, thanks.


#2

Warren D. wrote:

Has anyone among the members made database application in Ruby? I want
to learn ruby and create a desktop database application like Point of
Sale, Inventory, Library management System etc wherein updates in 2 or
more tables is done, please helpby uploading your sample projects.Even
if it is not a complete database application as long as it shows how to
update 2 or more tables in a 1 to many or many to many realtionship in a
MYSQL, thanks.

I haven’t tried this, but would this help you:
http://rsqlitegui.rubyforge.org/
It’s a desktop GUI software for the SQLite database, written in Ruby.

Cheers,
Mohit.
1/16/2009 | 3:13 PM.


#3

Warren D. wrote:

Has anyone among the members made database application in Ruby? I want
to learn ruby and create a desktop database application like Point of
Sale, Inventory, Library management System etc wherein updates in 2 or
more tables is done, please helpby uploading your sample projects.Even
if it is not a complete database application as long as it shows how to
update 2 or more tables in a 1 to many or many to many realtionship in a
MYSQL, thanks.

See also the answers you got when you asked this exact same question
last month.
http://www.ruby-forum.com/topic/172298

You seem to be asking two separate questions:

  • can I have sample code for a GUI application?
  • can I have sample code for MySQL database access?

Both of these depend entirely on which GUI framework (*) and which
database framework (**) you’re going to use. Of course, your choice may
be influenced by what you see. There are many previous threads you can
read discussing the pros and cons of each.

(*) e.g. tk, fox, ruby-cocoa, shoes, … I’m afraid I don’t use any of
these and I’m sure I’ve missed some other important options

(**) e.g. ActiveRecord, sequel, datamapper, og, ruby-dbi, or even direct
low-level ruby-mysql / mysql-ruby

Each one comes with its own documentation and code samples you can run
and play with.


#4

On Jan 16, 6:08 am, Warren D. removed_email_address@domain.invalid wrote:

Has anyone among the members made database application in Ruby? I want
to learn ruby and create a desktop database application like Point of
Sale, Inventory, Library management System etc wherein updates in 2 or
more tables is done, please helpby uploading your sample projects.Even
if it is not a complete database application as long as it shows how to
update 2 or more tables in a 1 to many or many to many realtionship in a
MYSQL, thanks.

Posted viahttp://www.ruby-forum.com/.
You can use Rails ActiveRecord with any GUI toolkit, it doesn’t depend
on the rest of Rails.

QtRuby includes a couple of ActiveRecord based ‘model’ classes (that
is Qt models, not ActiveRecord ones) to make it easier to use for
showing database data in Qt::TableView and Qt::TreeViews.

– Richard


#5

On Jan 15, 2009, at 11:08 PM, Warren D. wrote:

Posted via http://www.ruby-forum.com/.

Warren,
Check out Monkeybars (http://monkeybars.org), a JRuby GUI framework
that’s BYOM (Bring Your Own Model). We actually have commercial
applications written in Monkeybars (http://getjotbot.com) that are
driven by a database. JotBot uses Sequel for its ORM to connect to a
local H2 (think SQLite) database, and an app I’m writing for a client
right now is using ActiveRecord which connects to MySql. Apps written
in Monkeybars are cross platform, and don’t require your users to
install Ruby in advance. Rawr helps bundle these apps together, so you
can distribute native .app and .exe files for OS X and Windows.

We’re on #monkeybars on freenode, and we’re active on the mailing list.


#6

Thanks a lot i really appreciate your help, i’l try to visit monkey
bars,
i’m trying to build a POINT OF SALE for my little retail business. i
hope
you can further help me on this.

Cheers