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
0
votes
1 answer

Is there any possibility to connect PWA desktop app with sqlite database?

I have created PWA application. As my requirement says, my PWA application should work for both online and offline as of now online i have done but facing problem with offline because i should not use service worker or any browser level storage. I…
Deepashree Kannoor
  • 21
  • 3
0
votes
2 answers

trying to install sqlite3 gem on OS X snow leopard; seem to be missing some headers

I run the following command and am seeing the below issue... $ sudo gem install sqlite3-ruby OR $ sudo env ARCHFLAGS="-arch x86_64" gem install sqlite3-ruby Building native extensions. This could take a while... ERROR: Error installing…
Ringo Blancke
  • 2,444
  • 6
  • 30
  • 54
0
votes
1 answer

Error when trying to install sqlite3 "sudo gem install sqlite3" on mac

This is the error message I am getting, how can I fix this? Building native extensions. This could take a while... ERROR: Error installing sqlite3: ERROR: Failed to build gem native extension. current directory:…
gemsweetrolls
  • 1
0
votes
1 answer

How should one access windows files with WSL in VSCode?

The problem I'm having is related to starting heroku up with the WSL Bash console built into VSCode. Basically, it's my understanding that WSL maps your windows files with a slightly different path (using /mnt/drive/file), but why is it that these…
Hans Foster
  • 53
  • 9
0
votes
1 answer

ERROR: Failed to build gem native extension when installing Installing sqlite3 (1.3.3)

I am trying to start up my first rails project. Im on Mac OS X 10.6.7, have Xcode4 installed, ruby 1.9.2, rails 3.0.1 When I type bundle install I get this error: ~/rails_project/first_app$ bundle install Fetching source index for…
Tiffany
  • 1
  • 1
  • 1
0
votes
2 answers

Why do I get this sqli3 error in Ruby on Rails?

I have a problem with my RoR application. It boots up just fine, but when I open it I get the following error: It says it's a framework error: activerecord (5.0.7.2) lib/active_record/connection_adapters/sqlite3_adapter.rb:27:in…
Shannarra
  • 521
  • 4
  • 17
0
votes
1 answer

Cannot load sqlite3_native.so when trying to rake assets:precompile

I'm following a tutorial of Ruby on rails from this website: https://rails-3-2.railstutorial.org/book/beginning#sec-heroku_setup and I'm currently stuck at a part where it's telling me to run the command: rake assets:precompile It's giving me this…
j j S
  • 56
  • 4
0
votes
1 answer

mingw32: key on rails

When I try to boot up a rails server I get an error like Could not find gem 'sqlite3 (~> 1.4) x64-mingw32' in any of the gem sources listed in your Gemfile. . Later when I do bundle install or gem install sqlite3 error: mingw32: key…
xxxecute
  • 194
  • 2
  • 9
0
votes
1 answer

installing errors Ruby on Rails (Windows 7 & 10)

I already searched for a lot of questions on the internet but couldn't solve the error. I tried on both Windows 7 and 10 but ran into the same error. After I installed Ruby and Rails and sqlite3, and typed in rails new myproject in a command…
Todd
  • 399
  • 3
  • 18
0
votes
1 answer

Ruby On Rails Database

Whenever I run the command rvmsudo rake db:migrate (I need to use rvmsudo because I'm using rvm), the sqlite3 files generated are owned by root. ls -l db/*.sqlite3 Because of this, I keep on getting a SQLite3 Read Only Error whenever I try to do…
LanguagesNamedAfterCofee
  • 5,782
  • 7
  • 45
  • 72
0
votes
1 answer

How to order by, sum, and join using ActiveRecord

I have two tables: USERS id name ------------ 1. bill 2. dave 3. kate 4. sara and GAMES score user_id ------------------ 10 1 0 1 0 2 10 3 0 2 10 3 0 3 0 …
lbirts
  • 1
0
votes
0 answers

Remove Index on ActiveRecord[5.1] replacing model_id with nil

I am trying to remove a reference column from my database, locally using sqlite3. Was getting the SQLite3::ConstraintException: FOREIGN KEY constraint failed: DROP TABLE "features" so I tried removing the foreign key first. That did not change…
madav
  • 2,918
  • 1
  • 13
  • 17
0
votes
1 answer

gem install sqlite3-ruby

When I try install sqlite3-ruby, I get # gem install sqlite3-ruby Building native extensions. This could take a while... ERROR: Error installing sqlite3-ruby: ERROR: Failed to build gem native extension. …
JuanPablo
  • 23,792
  • 39
  • 118
  • 164
0
votes
0 answers

How to install SQLite3 for Rails on server without root access

I'm trying to create an Ruby on Rails "Hello World" application on our managed server where no root or sudo is possible. Ruby is version 2.3.3p222, Rails is v5.2.4.1. I used rails new testproject to create my "Hello World" test. This fails in bundle…
Klaus Friese
  • 109
  • 1
  • 10
0
votes
0 answers

Missing column on table when testing seed data with sqlite3 and rails

I set up the Many to Many a couple days ago and came back to the part where we add seed data to test. I added this: superman = Hero.find_or_create_by(name: 'Superman') drmanhattan = Hero.find_or_create_by(name: 'Dr.…
user3251999
  • 15
  • 6
1 2 3
…
14 15