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
1
vote
1 answer

How to download and run sqlite3 on windows ? I need to use it with ruby on rails

Im trying to install Ruby on Rails on my Windows 10 PC. for this is also want sqlite3 So I downloaded a precompiled binary for Windows, from https://www.sqlite.org/download.html The downloaded zip contains only a sqlite3.dll and sqlite3.def file.…
Kim Kardashian
  • 81
  • 2
  • 8
1
vote
2 answers

Upload Image by TKinter Filedialog functions and stored by another button

Simply, I upload image by tkinter.filedialog functions and wanted the image to be stored to the database simultaneous with the name I provide by clicking another the button, the name stored well but not the image. Here is the code. from tkinter…
Murad Amer
  • 11
  • 1
1
vote
0 answers

open attribute is not working for sqlite3dbm

I have to develop dbm module using sqlite. Hence I have imported sqlite3dbm with open attribute to create the new database. But it is saying "module 'sqlite3dbm' has no attribute 'open'". The code which i m trying to run is from internet. Is…
Bhagya
  • 31
  • 5
1
vote
1 answer

unable to build sqlite3-ruby on dreamhost (debian lenny/5.0.8)

I'm not able to build sqlite3-ruby gem on dreamhost (trying to setup diaspora), I get following errors Installing sqlite3 (1.3.3) with native extensions /usr/lib/ruby/1.8/rubygems /installer.rb:482:in `build_extensions': ERROR: Failed to build gem…
j4v4m4n
  • 101
  • 8
1
vote
1 answer

Ubuntu: could not install sqlite3 - Failed to build gem native extension

I am using Ubuntu 20.10 and when trying to install the sqlite3 gem while creating a new rails project it throws: Building native extensions. This could take a while... ERROR: Error installing sqlite3: ERROR: Failed to build gem native…
wattepower
  • 11
  • 2
1
vote
1 answer

Ruby Bundler sqlite3 extension dependency on local libruby in user's folder

OS: macos with brew Ruby version manager: rbenv I am using bundler (2.1.4) to deploy my application with all the required gems. I am currently on Ruby 2.2.4 and trying to update to Ruby 2.5.5. I am also updating the various gems to the latest…
Rojj
  • 1,170
  • 1
  • 12
  • 32
1
vote
1 answer

Unrecognized token in sqlite3 while creating a table

i know there are lot of solution regarding unrecognized token but all of them ocuuring while executing insert() query but i got error while creating a table. Here is a piece of code def table_stats(): c.execute("""CREATE TABLE stats( …
kashif
  • 21
  • 6
1
vote
1 answer

Ruby ORM inserted records

I've run into a problem with my ruby ORM using sqlite3 my orm has a save function that saves a record in the database and sets the objects instance id to the id of the new record: def save sql = "INSERT INTO #{table_name_for_insert}…
SVRourke
  • 19
  • 5
1
vote
2 answers

Mysql2::Error::ConnectionError: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Recently I tried to change the database of my Rails application. I was using sqlite3 and I wanted to change it to MySQL. I followed the steps of this tutorial :…
Gabriel Carneiro
  • 75
  • 2
  • 10
1
vote
0 answers

How do I get ActiveRecord to save my table?

I have searched for a similar problem for the past couple hours and have not found a solution. My database contains a User, Game, and Save class with migration files to correspond. When I run my game, it says rake…
Toby N Boudreaux
  • 11
  • 2
1
vote
1 answer

Problem to display Sqlite3 View in ruby-2.7

I am having problems displaying a view I created (successfully in sqlite3) using ruby. Below is the sqlite view CREATE VIEW members_ytd_totals AS SELECT id AS MemberID, first_name, last_name, ipu_dues.total AS TotalDues, …
Charlie_oscar
  • 57
  • 5
1
vote
1 answer

rails db:migrate giving warning and not creating any table

When I start doing code on (see image below) rails I saw rails guide to getting start with it. There's a command rails db:migrate for creating table and stuff. But its giving only warning and not creating any table.
beerender singh
  • 1
  • 1
1
vote
2 answers

SQLite3::SQLException: no such table: main.creators: (event and user model with simple has many, belongs to associations)

I am trying to save an event with a name and a creator_id: 1 (which exists) but am getting this error and I can't find any references online, can someone see what's wrong with my model? Users have events, and events belongs to user as creator.…
DannyCode
  • 21
  • 3
1
vote
1 answer

Ruby SQLite3 OCRA executable missing sqlite_native.so

I am trying to package the following ruby script with OCRA (I am on Windows 10, Ruby 2.6): require 'sqlite3' puts SQLite3::VERSION Running this in cmd works properly: C:\Users\monday\Documents\projects\sqlite3_test>script.rb 1.4.2 When I package…
Big Monday
  • 590
  • 1
  • 5
  • 15
1
vote
1 answer

We're sorry, but something went wrong. - Heroku Hosting

I wanted to try Heroku as a hosting method. I can go to the home page, but when I press "Sign Up" I get "We're sorry, but something went wrong." message. Is there any way of using sqlite3 instead of Postgres? If not on Heroku, then maybe on some…
SablyTv
  • 49
  • 9
1 2 3
…
14 15