Questions tagged [sqlite]
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
103
questions
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)...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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. ...
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 ...
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 ...
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?
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.
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 ...
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.
...
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....
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 ...
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/...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...