Questions tagged [sqlite]

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

Filter by
Sorted by
Tagged with
0 votes
1 answer
914 views

Empty Asterisk 12 CDRs in SQLite3 database

Using: CentOS 6 Asterisk 12 cdr_sqlite3_custom.so cdr_sqlite3_custom.conf (deliberately simplified): [master] table=>cdr columns=>calldate, clid, test values=>'${CDR(start)}','${CDR(clid)...
Paul Basov's user avatar
0 votes
1 answer
2k views

SQLite on latest PHP (>= 5.4)

http://www.php.net/manual/en/sqlite.installation.php Beginning with PHP 5.4, this extension is available only via PECL. http://pecl.php.net/package/SQLite This package is not maintained anymore ...
Ansis Māliņš's user avatar
0 votes
1 answer
429 views

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
user938363's user avatar
0 votes
0 answers
284 views

Can't listen to port 4445; sqlite3

So I have a dedicated machine running Ubuntu 12.04 server with FreePBX 2.9. Earlier I was attempting to familiarize myself with SQL via sqlite3, but I received this dreaded error: SQLite header and ...
b0dhi_'s user avatar
  • 1
10 votes
1 answer
20k views

How can I convert an MS Access database (.mdb) file to a Sqlite database (.db) file? [closed]

Can anybody help me convert an MS Access (.mdb) file to an Sqlite database (.db) file? I need to convert all the tables and dump the data inside. Are there any tools available, or is there any API ...
Rajendar's user avatar
  • 101
1 vote
1 answer
616 views

How do I back up my rails database on the fly?

I have been looking for a way to back up my app's database which is hosted by heroku. It uses an sqlite database. What I am looking for is a way to add a button on my site which will allow me to ...
Danny Dyla's user avatar
0 votes
2 answers
189 views

database on SSD: data only or the DBM program too?

I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s ...
simone's user avatar
  • 1,281
1 vote
1 answer
5k views

Not Installing Sqlite 3 on CentOS correctly

I need to get sqlite 3 installed for php on a CentOS but its still telling that it's not installed. I did the command and got this message: yum install sqlite Package sqlite-3.6.20-1.el6.x86_64 ...
MCHam's user avatar
  • 125
2 votes
1 answer
163 views

Sqlite enabling in PHP 5

I know similar questions have been posted but they don't answer my question as far as I can tell. I have PHP 5.3 that is supposed to have sqlite3 extension installed php.ini does NOT have sqlite3 ...
user123959's user avatar
2 votes
0 answers
861 views

Can you use SQLite 64 bit odbc from powershell

I have installed 64 bit ODBC driver for SQLite, downloaded from this page. I am running PowerShell version 2 on Windows 7. In the ODBC configuration I create a system DSN with name LoveBoat, pointing ...
Levin Magruder's user avatar
1 vote
1 answer
1k views

DB encryption for Django web app without storing key on server

We are setting up a virtual private server (not hosted by us), on which we will be user testing our Django-based web application. The user-generated content produced in these tests will be very ...
Xun Yang's user avatar
  • 111
3 votes
2 answers
24k views

PHP install sqlite3 extension

We are using PHP 5.3.6 here, but we used the --without-sqlite3 command when compiling PHP. (It stands in the 'Configure Command' column). But, it is very risky to recompile PHP on that server; there ...
www.data-blogger.com's user avatar
1 vote
3 answers
6k views

PHP enable sqlite phpinfo states --without-sqlite

I've seen similar questions but none that address my situation adequately. I'm running Apache and PHP 5.3.6 on a amazon cloud server. phpinfo keeps stating that sqlite is disabled. At least that ...
James John McGuire 'Jahmic''s user avatar
0 votes
1 answer
701 views

undefined symbol: sqlite3_initialize

When I try to deploy my Rails application to an Apache server using Passenger, I get the following error in the logs: undefined symbol: sqlite3_initialize I get the same error when just running ...
johntheripper's user avatar
3 votes
2 answers
4k views

How to dump sqlite database to ascii?

For some reason Firefox won't let me see more than 1 month of history, despite I have set to to remember for 90 days. places.sqlite is 18MB so I would like to dump the content of it, and see if I can ...
Sandra's user avatar
  • 10.5k
5 votes
2 answers
13k views

How to convert a postgres database to sqlite

We're working on a website, and when we develop locally (one of us from Windows), we use sqlite3, but on the server (linux) we use postgres. We'd like to be able to import the production database into ...
luqui's user avatar
  • 153
1 vote
2 answers
12k views

How to install precompiled binaries in linux

I am trying to install a pre-compiled sqlite version 3 (sqlite3) binary in linux. I created a directory /home/username/src and I placed the zip file in the directory then unzipped the file. What I was ...
user avatar
0 votes
1 answer
396 views

cron to merge xml into sqlite every two hours - lamp

I'm looking to auto pull an xml file from an offsite url and merge it into a sqlite db every two hours. The server is lamp. (If it is too difficult to do for sqlite, then merging the xml into a mysql ...
Jeffrey's user avatar
  • 103
1 vote
1 answer
3k views

How do I install php with sqlite support in AWS EC2?

I'm trying to run an AWS EC2 instance for a facebook app. I chose the micro Amazon linux 32-bit as my OS. I'm able to SSH in and install PHP with yum, but when I run phpinfo() I see --without-sqlite ...
James's user avatar
  • 113
2 votes
1 answer
4k views

How can I enable encryption for SQLite3 in PHP5.3? [closed]

The php manual for SQLite3::open has this information: public bool SQLite3::open ( string $filename [, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE [, string $encryption_key ...
meouw's user avatar
  • 123
1 vote
2 answers
3k views

Installing sqlite gem fails on AWS Linux instance with sqlite-devel libraries installed

I'm running an instance built off ami-595a0a1c. I am trying to install the sqlite3 (or sqlite) gem and it's failing with the below error: $ sudo gem install sqlite3 Building native extensions. This ...
Scott's user avatar
  • 11
7 votes
8 answers
5k views

Is this idea about distributed database server with centralized storage feasible?

I often use SQLite for creating simple programs in companies. The database is placed on a file server. This works fine as long as there are not more than about 50 users working towards the database ...
David's user avatar
  • 447
1 vote
3 answers
11k views

How do I activate SQLite3 on PHP 5.3.3 Centos 5?

I have reviewed the previous questions on this and they don't seem to cover what exactly I'm looking for, before I start, I'm no server admin. I'm trying to help get this server up and active and I ...
user avatar
0 votes
1 answer
6k views

Install PHP5 with SQLite3 on Debian Lenny

There is no apt-get install php5-sqlite3, as its refereed by php5-sqlite thus, i did: apt-get install sqlite3 and then apt-get install php5-sqlite Restarted apache2. When I run echo ...
ParoX's user avatar
  • 302
0 votes
4 answers
1k views

Installing newer version of installed RPM from source (CentOS)

I've got sqlite 3.3.6 installed through ''yum'', but I need 3.6+. There's no RPM to be found for it, so I decided to install from source. That was simple enough, but now I have both versions installed,...
Trevor Burnham's user avatar
0 votes
2 answers
3k views

sqlite3 support on centos with PECL?

i just realized that the rpm version of php that i have installed on the server don't have sqlite support (well it have the PDO support but for some reason don't work) so i installed as a PECL ...
shadow_of__soul's user avatar
8 votes
2 answers
7k views

How to Link an SQL Server 2008 Server to an SQLite Server?

I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this? I have searched far and wide, but found no solution for this problem. ...
user48962's user avatar
  • 181
1 vote
1 answer
723 views

sqlite and php enabling

I have a fresh install of fedora 12 and am trying to get php and sqlite working I installed php through: yum install php php-devel php-pdo and restarted apache. Php pages are working just fine but ...
jcb344's user avatar
  • 693
2 votes
2 answers
6k views

Enabling Sqlite3 for php on fedora

I am trying to get php with sqlite working on my fedora server. In the phpinfo is see that ./configure was set with the option --without-sqlite3. From what I have read these means that I might have to ...
jcb344's user avatar
  • 693
2 votes
2 answers
409 views

What database app is best for including in a distributable app?

MySQL versus SQLite, for example? I understand that MySQL is harder to setup and configure... Would SQLite or another db be better suited in this regard?
lions_leash's user avatar
2 votes
1 answer
424 views

Request Tracker sqlite to mysql migration

I'm planning to migrate request tracket 3.6 from present server. The rt is running on sqlite and the new one will be mysql. Is there any way to migrate sqlitedb to mysql server. Thanks in Advance.
Caterpillar's user avatar
  • 1,142
0 votes
3 answers
1k views

An SQLite/STDIN Conundrum, Specific to AIX

I'm been playing around with SQlite at work, specifically with trying to get the sqlite3 command line tool to accept stdin instead of a file. Sounds easy enough, on linux you can execute a command ...
user avatar
0 votes
1 answer
3k views

sqlite : Fatal error: Call to undefined function sqlite_escape_string()

I use a script that requires SQLITE, On my previous host, it worked. On localhost it works. On my new dedicaced server, it doesn't. I use PHP5 of course, you can access phpinfo() of the server. ...
Tristan's user avatar
  • 498
2 votes
1 answer
2k views

Can't get php+sqlite working

I'm struggling all morning to make php work with an sqlite database. Here is a piece of php code that I try to execute: #less /var/www/html/test.php <?php $db=new PDO("sqlite:/var/www/test....
facha's user avatar
  • 1,398
2 votes
2 answers
680 views

Why do I get a PHP 5.2.6 segmentation fault when using PDO_SQlite?

This is an installation on ModWest's shared hosting. I have enabled both PDO and PDO_sqlite on the server and phpinfo() verifies both are running. When I access PDO itself, I'm fine, and getting a ...
danieltalsky's user avatar
0 votes
1 answer
979 views

Why is apache/passenger unable to open the sqlite3 rails database file?

I'm running apache2/passenger2.0.3 (ubuntu 9.10 packages). I can start up Webrick in the rails folder and run the app perfectly as I do on my development box with script/server Why then does apache/...
sendos's user avatar
  • 21
1 vote
1 answer
867 views

svnadmin: SQLite is required to be compiled and run in thread-safe mode

I've used apt-get to install Subversion and SQLite on my Ubuntu VPS, however, I'm getting this error when I try to use svn: svnadmin: SQLite is required to be compiled and run in thread-safe mode ...
user avatar
1 vote
1 answer
351 views

weird text appearing when using PHPBB >v3.0.1 XAMPP windows SQLite

This is the strangest, most baffling problem I have ever encountered. Basically when I use any PHP forum software other than phpbb it works fine but when I use any version of phpbb greater than 3.0.1 ...
user avatar
2 votes
1 answer
6k views

What should I change in php.ini to enable usage of sqlite from PHP?

At the moment I cannot use sqlite from PHP. Probably I need to change something in my php.ini file. In my php.ini file I found 2 lines containing "sqlite": [sqlite] ;sqlite.assoc_case = 0 Does ...
Roman's user avatar
  • 2,619
5 votes
9 answers
28k views

Why class 'SQLiteDatabase' is not found in /var/www/*.php?

I am trying to use sqlite from PHP. I have the following simple code: <?php $db = new SQLiteDatabase("test2.sdb"); unset($db); ?> As the result of this code (which I execute in the command ...
Roman's user avatar
  • 2,619
8 votes
5 answers
6k views

SQLite on a production server? [closed]

I have known about SQLite for a long time and I know it is blazing fast, but I have never tried it in a production server. I was never able to find a solid estimate on how much traffic it could handle ...
Dr Hydralisk's user avatar
0 votes
1 answer
3k views

How to install PHP5.3 and SQLite3 on Ubuntu 8.04

I got a Ubuntu Hardy VPS and I am trying to install PHP5.3 with SQLite. I added the dotdeb PHP5.3 repository and succeeded in installing PHP5.3. But I need to install SQLite as well. When I'm trying ...
user avatar
3 votes
2 answers
489 views

Adobe Acrobat Sqlite errors with Mac OS X network accounts

We have set up network accounts for our Snow Leopard Users on several Macs, which work great except for applications that use a local Sqlite database for their preferences/cache. The biggest problem ...
Jon Rhoades's user avatar
  • 5,017
0 votes
1 answer
666 views

svnadmin: SQLite is required to be compiled and run in thread-safe mode

I am getting this error when trying to use svn on my shared hosting account [hostmonster] svnadmin: SQLite is required to be compiled and run in thread-safe mode My SQLite is in /usr/bin How can i ...
vinayrks's user avatar
  • 157
1 vote
3 answers
572 views

Dump Trac DB on Windows/XAMPP

I have a Trac instance running on a WindowsXP machine with XAMPP. I am trying to migrate the trac instance to a newer Linux-based machine. However, I'm having a hard time getting the database to ...
Whiteknight's user avatar
5 votes
7 answers
8k views

Rsync / Sqlite database

Does anyone have ever tried rsync'ing sqlite database? Is it possible to access the data while it gets syncronised?
mnml's user avatar
  • 347
0 votes
1 answer
720 views

JDBCRealm can't find sqlite file

My authentication fails with java.sql.SQLException: no such table: credentials where credentials is the name of the user/password table. I have checked the db file and the table is there. I think ...
user avatar
1 vote
1 answer
146 views

SQLite question? Podcast Producer server failure

Suddenly this morning none of my recording machines can connect to the server. There were no software updates on the client or server side this weekend. It looked like a firewall issue at first, but ...
Doug Chase's user avatar
2 votes
4 answers
2k views

Best system to serve sqlite databases to webservers over a network?

I am helping in setting up a web service in which user data will be stored in sqlite databases on a server running perhaps Samba, and one or more web servers will read and write to those databases on ...
jberryman's user avatar
  • 924
7 votes
4 answers
5k views

Can SQLite be used with GlusterFS?

I want to build a distributed storage based on GlusterFS with Automatic File Replication (AFR) to store users files in a fault-tolerant way. But I also want to access an SQLite3 database stored on ...
math's user avatar
  • 207