The sqlite tag has no wiki summary.
0
votes
0answers
16 views
Is it possible that SQLite has locking issues due to being on a VPS?
I've had a SQLite driven (ruby on rails) site running for a while now on a dedicated server without any major issues and now I'm thinking of moving it to a VPS.
But when on the VPS the site randomly ...
0
votes
1answer
468 views
How convert ms access database (.mdb) file to Sqlite database (.db) file
Please can somebody help me converting MS access (.mdb) file to Sqlite database(.db) file, here I need to convert all the tables and dump the data inside.
Do we have any tools available ? (OR) Do we ...
0
votes
0answers
233 views
svn: E200030: sqlite: database disk image is malformed @ checkout
The .svn folder doesn't exists yet. I tried deleting it after it was created, but I get the same issue again
@:/var/www/htdocs$ svn checkout https://host/svn/trunk/ .
svn: E200030: sqlite: database ...
1
vote
0answers
96 views
thttpd slow and huge resource usage
I have a thttpd server with php, xml2 and sqlite3 running on an embedded arm linux system. In general the system is working, but my sites are loaded really slow (ca. 20s per site, doesn't matter if ...
0
votes
1answer
162 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
2answers
119 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 ...
0
votes
0answers
28 views
How to collect perf counters on servers and view results as beautiful charts? [closed]
I need your help with knowlenge. I need to collect performance counters from 4-6 high-loaded servers. Each server running Windows. I need to collect performance from servers and store performance to ...
0
votes
1answer
222 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 ...
0
votes
0answers
60 views
timeout for php-sqlite session [closed]
I use a sqlite3 database via an PHP-based webinterface.
This works usually well enough as we only have a handful of users, but if one user experiences a problem during a transaction (loses ...
1
vote
1answer
84 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 ...
0
votes
0answers
199 views
Can you use SQLite 64 bit odbc from powershell
Basically, my question is "Does this combo work for anyone," and, "Can you see what I am doing wrong"
I have installed 64 bit ODBC driver for sqlite, downloaded from this page. I am running ...
1
vote
0answers
186 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 ...
0
votes
1answer
260 views
Why can't I install sqlite-devel package?
I'm try to install the sqlite-devel package on a Red Hat 4.1.2-51 x86_64 Linux server with rpm command:
# rpm -i ftp://ftp.muug.mb.ca/mirror/fedora/epel/4/x86_64/sqlite-devel-3.3.6-0.3.el4.x86_64.rpm
...
0
votes
2answers
3k 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 ...
0
votes
2answers
860 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
1answer
277 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 ...
0
votes
2answers
627 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 ...
2
votes
3answers
2k 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 ...
0
votes
2answers
361 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
1answer
169 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
1answer
876 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 ...
0
votes
1answer
656 views
How can I enable encryption for SQLite3 in PHP5.3?
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
2answers
535 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 ...
4
votes
7answers
2k 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 ...
0
votes
3answers
2k 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
1answer
4k 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
4answers
704 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 ...
0
votes
2answers
2k 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
2answers
3k 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. ...
0
votes
1answer
468 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 ...
1
vote
2answers
2k 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
2answers
139 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
1answer
287 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
3answers
476 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
1answer
1k 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.
...
1
vote
1answer
501 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 ...
2
votes
2answers
427 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
1answer
608 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 ...
1
vote
1answer
451 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
1answer
261 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 ...
0
votes
1answer
3k 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 ...
2
votes
6answers
9k 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 ...
3
votes
5answers
2k 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
1answer
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
2answers
345 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
1answer
592 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
3answers
408 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 ...
0
votes
4answers
1k 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
1answer
367 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 ...
1
vote
1answer
130 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 ...
