[sqlite] SQLite db file size and NFS file locking issue

Hello- Is there any limit (besides the OS files system limit) on how big the db file size can be with SQLite? Also, is there any NFS locking issue with SQLite database? Sometimes if a client opens the files and die, do we have problems reading the file again because NFS lock for the file

[sqlite] sqlite driven web-site

Dear SQLite community- I want to develop a dynamic web-site (for small group of people < 5-10). For this I am thinking of using SQLite. Couple of questions: * Are there some docs and/or package available to do something like this? * I would like to use perl as the programming interface - this

RE: [sqlite] XML to SQLite upload

Thanks for answers. Sorry, I was not clear in my previous email. I do know the structure of the for the XML - I was wondering if there was a direct upload capability, once I know the structure of the XML. Vivek >-Original Message- >From: A. Pagaltzis [mailto:[EMAIL PROTECTED] >Sent:

[sqlite] XML to SQLite upload

Does someone have XML to SQLite upload utility in perl/C++? Vivek

[sqlite] multiple database attach with SQLite

Hello- I have some questions regarding attaching multiple databases with SQLite: * What is the max number of databases which can be attached to a single process using SQLite? * Has someone tried attached large number of databases with SQLite, and are there any performance

[sqlite] enum in SQLite

I would like to know the following: *Does SQLite support enum like MySQL? If yes, how to use it *If not, is there another way to model enumeration in SQLite? And/or any plans going forward to support enums natively in SQLite? Rajan

[sqlite] sqlite and multiple databases

Hello- I have few questions regarding usage-model of multiple databases with SQLite. I understand SQLite allows for attaching multiple databases in a single session. My questions are: *Do the schema for multiple databases need to be same for attaching with SQLite in single session?

[sqlite] Organizing large database into multiple files

Hello- I have a need to store large volumes of data (~5-10G) in SQLite database. The data which I am storing is organized hierarchically. The schema for my database has foreign-key constraints, the tables are interrelated. My questions: - How can I organize the entire database into

RE: [sqlite] Question about automatic schema creation from custom data-strucutre for persistence storage

he answer >> is probably no. Unless you want to parse your header file yourself, >> or something like that. >> >> With Java or another high-level programming language that supports >> introspection it would be possible I think. >> >> >> "Rajan, Vivek K"

[sqlite] Question about automatic schema creation from custom data-strucutre for persistence storage

Hello- Has anyone had experience with automatically creating schema from a custom data-structure for persistence storage using SQLite? So, in my C/C++ program I have the following type of data-structure: struct _trace { std::string name; std::string prop;

[sqlite] Embedded mySQL & SQLite

Has anyone done comparison between embedded mySQL and SQLite? Would like to request feedback/comments on how do the two technologies contrast/compare? Vivek

[sqlite] methods to improve insertion speed with SQLite

Hello- In my application, I perform large number of insertions (~100K) to create a SQLite database. The method which I currently have is following: - Start a transaction - Insert into database (~100K inserts) - During the insert process, I also have to query the already inserted

[sqlite] Question about SQLite and spatial data

I have a need to store spatial and connectivity data (think verilog netlist with x, y coordinate information) in a persistence on-disk file. I am looking at different SQL-based databases and am wondering if anyone has recommendations/opinions on how good SQLite is for: - Storing spatial data.