Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sqlite]

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

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format.

Think of SQLite not as a replacement for Oracle but as a replacement for fopen()

Executive Summary

102 questions
2
votes
2 answers

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 recompile or reinstall php with with sqlite. I…
jcb344
  • 643
  • 2
  • 7
  • 8
2
votes
2 answers

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
  • 48
  • 5
2
votes
1 answer

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
  • 1,122
  • 2
  • 22
  • 47
2
votes
1 answer

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
facha
  • 1,298
  • 2
  • 16
  • 26
2
votes
2 answers

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 meaningful error.
danieltalsky
  • 131
  • 5
2
votes
1 answer

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 semicolon in front of the line means that line is…
Roman
  • 2,439
  • 9
  • 32
  • 32
2
votes
1 answer

On a system with fapolicyd enabled, how do I permit Java to run sqlitejdbc.so, which has a unique filename at each start?

My issue is fairly similar to this one: I have a Java application running on Rhel 8 that relies on an sqlite-jdcb driver. Unlike in that issue, my issue isn't with my filesystem being mounted with noexec. Instead, its with fapolicyd prohibiting java…
ADS103
  • 116
  • 1
  • 6
1
vote
3 answers

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 cooperate. I try to dump the db with this…
Whiteknight
  • 183
  • 1
  • 1
  • 5
1
vote
0 answers

How to fix the Sqlite3 differing versions using Python?

I had sqlite version 3.7.17 on centOS. I then installed from source code 3.28.0. Unfortunately the sqlite3 python module is still using version 3.7.17. Do I have to recompile python? [root@jenkins ~]# python3.6 Python 3.6.8 (default, Jun 21 2019,…
tread
  • 413
  • 2
  • 4
  • 21
1
vote
2 answers

Using SQLite through PHP without completely disabling SELinux

I'm trying to access an SQLite file on a CentOS7 box using PHP and the PDO library. I was getting read-only errors just like this question - https://stackoverflow.com/questions/3319112/sqlite-read-only-database And per that question, the answer was…
Pipupnipup
  • 11
  • 3
1
vote
0 answers

What are the options to "atomically" stage different files (not having ZFS)

I need to take a backup of an SQLite3 DB matching the state of other applications writing to disk, besides a vault using the filesystem as a backend. I need to do this in a system with no ZFS so no snapshots could be taken. Currently trying a basic…
nbari
  • 548
  • 1
  • 8
  • 25
1
vote
1 answer

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 the connection is being built and the PodPro…
Doug Chase
  • 753
  • 3
  • 12
  • 22
1
vote
1 answer

Databbase file structure on disk

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most part I understand the SQLite data file layout. I…
Yorick de Wid
  • 113
  • 3
1
vote
1 answer

yum list showing wrong version

I am trying to install freeswitch and while configuring it, it spits out the message. "checking for sqlite3 >= 3.6.20... Package sqlite3 was not found in the pkg-config search path. Perhaps you should add the directory containing `sqlite3.pc' to the…
Arslan Mehboob
  • 115
  • 5
1
vote
1 answer

Distributing load from Django App

I am currently approaching stages to move my first large-scale application out of development. I have talked with some CTOs who know what they're talking about, and I have been advised to do the following: Break up launching phases into a 4 step…
jdero
  • 113
  • 5
1 2
3
4 5 6 7