Stack Overflow
Stack Overflow

Questions tagged [sqlite3-ruby]

The low level SQLite3 library for Ruby. This should only be used for questions about using the low level interface directly.

The SQLite3 gem provides low level Ruby bindings to the SQLite3 embedded database.

You must have the SQLite engine installed in order to build this module.

Links:

214 questions
2
votes
2 answers

sqlite3-ruby compilation and sqlite3 packaging for a rails app

We are currently trying to package sqlite3 and sqlite3-ruby with an application that will be released as open source (ruby/rails based). I am evaluating if it is possible to package sqlite3-ruby for Windows, Linux and Mac. My thoughts were, to…
z3cko
  • 3,054
  • 8
  • 40
  • 59
2
votes
2 answers

Problem installing sqlite3-ruby on cygwin

I'm getting error while trying to install sqlite3-ruby gem: gem install sqlite3-ruby-1.3.1.gem Building native extensions. This could take a while... ERROR: Error installing sqlite3-ruby-1.3.1.gem: ERROR: Failed to build gem native…
l245c4l
  • 4,135
  • 9
  • 35
  • 40
2
votes
1 answer

Very slow POST request with Ruby on Rails

We are 2 working on a website with Ruby on Rails that receives GPS coordinates sent by a tracking system we developped. This tracking system send 10 coordinates every 10 seconds. We have 2 servers to test our website and we noticed that one server…
Jahaa
  • 21
  • 2
2
votes
1 answer

Time fields in Rails coming back blank

I have a simple Rails 3.b1 (Ruby 1.9.1) application running on Sqlite3. I have this table: create_table :time_tests do |t| t.time :time end And I see this behavior: irb(main):001:0> tt = TimeTest.new => #
user24359
2
votes
1 answer

Ruby/SQLite3 results as hash returns duplicate data

I have the following code in my app.rb file: require 'sinatra' require 'json' require 'sqlite3' get '/api/clients' do db = SQLite3::Database.new "db/db" db.results_as_hash = true {clients: db.execute('SELECT * FROM…
norway-firemen
  • 395
  • 4
  • 21
2
votes
4 answers

ruby1.9.1 - sqlite3 problem on ubuntu 9.10 x64 (no such file to load -- sqlite3)

I have problem with sqlite3, because it is not working. irb(main):001:0> require 'sqlite3' LoadError: no such file to load -- sqlite3 from (irb):1:in `require' from (irb):1 from /usr/bin/irb:12:in `
' I have installed following…
doriath
  • 96
  • 5
2
votes
2 answers

Why is my rails server issuing deprecation warning and not connection to sqlite3?

I am starting rails by following this tutorial: http://ruby.railstutorial.org/ruby-on-rails-tutorial-book#sec-the_first_application which seems very nice. At the beginning, the author talks about the importance of the versions for the gems and…
JSBach
  • 4,679
  • 8
  • 51
  • 98
2
votes
3 answers

gem install sqlite3-ruby fails on cygwin

I am trying to install ruby on rails on cygwin but have hit a roadblock while creating a test app e.g., rails new my_test_app Looks like my install (ruby 1.9.3p429 (2013-05-15) [i386-cygwin], rails 3.2.13, gem 2.0.6, rake 10.1.0) had a gem missing…
ZeroGraviti
  • 1,047
  • 2
  • 12
  • 28
2
votes
1 answer

Load Error - Using MySQL with Ruby on Rails

I have been trying to use SQL with Ruby on Rails for quite sometime now and cannot seem to make it work. I've pretty much given up on SQLite, so my focus is now on MySQL. I have fully installed the program and it works on its own. However I cannot…
Jet Blue
  • 5,109
  • 7
  • 36
  • 48
2
votes
1 answer

I have Rails error with save method in ActiveRecord

I found this Error when call save method My Rails Envi: Rails 3.2.5, sqlite 3.7.12 (in GemFile 1.3.6), latest ActiveRecord Thanks You in Advance.
Kiattisak Anoochitarom
  • 2,157
  • 1
  • 20
  • 15
2
votes
1 answer

Rails 3.2.4 SQL query is caching results on find(:all)

I not total sure if this system is caching the data but it has some of the charcteristics of caching. Basicly I was messing with rails 3.2.4 and the system started to not display some of the results. I think this is dew to the default scope I put…
User128848244
  • 3,250
  • 3
  • 24
  • 22
1
vote
1 answer

Select unique records without natural keys

For example, I have table names: id integer primary key, name text unique and unique index for names(name). I want to select records by index-style syntax: (n12, nBill) = (Name[12], Name['Bill']) or with Name.get['Smitt']. As documentation says, it…
emett
  • 128
  • 13
1
vote
2 answers

How do I use Ruby to extract data from a SQLite3 database and output it as static HTML?

I want to write a script that retrieves data from a local SQLite3 database and then formats that data into an HTML file. I'm not sure what "tools" to use, but I guess I'll need the sqlite3 gem and then I was thinking about using Sinatra for the HTML…
joshu
  • 851
  • 2
  • 9
  • 18
1
vote
1 answer

Cannot install sqlite3 gem on Mac OS X 10.5.8 (Leopard)

Using Mac OS X 10.5.8 (Leopard) ruby 1.9.3p0 gem version 1.8.14 sqlite3 Version 3.7.9 I also have installed Xcode 3.1.4 (not sure if this is used for installation of gems). I fetched the sqlite3 gem gem fetch sqlite3 Then unpacked it gem…
Usering
  • 143
  • 3
  • 20
1
vote
0 answers

PG::DatatypeMismatch: ERROR: column "name_id" cannot be cast automatically to type integer HINT: You might need to specify "USING name_id::integer"

I experienced this error when I tried to run rake db:migrate. rake aborted! StandardError: An error has occurred, this and all later migrations canceled: PG::DatatypeMismatch: ERROR: column "developer_id" cannot be cast automatically to type…
Glenn Mwangi
  • 11
  • 2
1 2 3
…
14 15