The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
236 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
337 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
755 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
2k 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
781 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
486 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
764 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
639 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
296 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 ...
1
vote
1answer
4k 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 ...
3
votes
9answers
17k 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 ...
6
votes
5answers
3k 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
398 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
629 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
479 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
2k 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
490 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
136 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
4answers
651 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 ...
5
votes
4answers
2k 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 ...
35
votes
7answers
91k views

Why do I get sqlite error, “unable to open database file”?

Using my Django app, I'm able to read from the database just fine. When the application didn't have permission to access the file, it gave me this error: attempt to write a readonly database ...
5
votes
5answers
62k views

How do I enable SQLite on Linux/Apache/PHP?

To enable SQLite on my Windows/Apache/PHP setup, I uncomment the following lines in the php.ini file and restart Apache: extension=php_pdo.dll extension=php_pdo_sqlite.dll Now I have a VPS with ...