Well I figured out a few things.
\nHow to make a ruby app set up to use sqlite3
\nrails app-name -d sqlite3
\nHow to properly install sqlite3’s dll – put it in ruby\/bin
\nHow to check to see if you have a gem installed
\ngem list sqlite3
\nI am working towards a nice simple version of rails that will run on Windows and Mac from a USB stick.
\nOn the Mac, I am happy with Locomotive. On Windows – I like InstantRails – but do not like MySql as the database.
\nThe SQLite browser is dang cool and dang simple to install on both mac and PC.
\nhttp:\/\/sqlitebrowser.sourceforge.net\/
\nTextmate is a very very fun editor for the Mac and Rails. It instant-installs right from Locomotive. Sweet.
\nOn the PC – I like e-texteditor http:\/\/www.e-texteditor.com\/
\nThe dang sweetest thing so far is
\nAfter running
\nruby script\/generate model Thing
\nAnd making a simple database migration script like this:
\nclass CreateThings < ActiveRecord::Migration\ndef self.up\ncreate_table :things do |t|\nt.column :key, :string\nt.column :value, :string\nend\nend\ndef self.down\ndrop_table :things\nend\nend\nThen run this:\nruby script\/console\nAnd type this:\nx = Thing.new\nx.key='123'\nx.value = 'fred'\nx.save\nAbsolutely sweet - able to interact with the ORM from the command line - dang dang dang. Hib can eat its heart out.\nI still am confused as to why folks don't use SQLite3 all the time for simple stuff - like for teaching. These one-click installers should all use SQLite3 IMHO.\nAlso I wonder why people ever use anything other than migrations using the DB-independent syntax to populate\/organize tables. Urg.\nIt is too bad that the ruby \/ rails stuff does not put consistent line-ends in place. Some things work in vi others fail in notepad.exe - ah well - a good reason to get a sweet editor like TextMate or e-texteditor - and pay for them.\nTTFN - time to go buy some more 1GB USB sticks and a USB-2 controller.\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Well I figured out a few things. How to make a ruby app set up to use sqlite3 rails app-name -d sqlite3 How to properly install sqlite3’s dll – put it in ruby\/bin How to check to see if you have a gem installed gem list sqlite3 I am working towards a nice simple version […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-355","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/comments?post=355"}],"version-history":[{"count":1,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/355\/revisions"}],"predecessor-version":[{"id":2462,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/355\/revisions\/2462"}],"wp:attachment":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/media?parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/categories?post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/tags?post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}