[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

RE: [sqlite] spatial sqlite anyone ?

Hello Noel- I am interested in this as well - I have wanted spatial feature in SQLite for a while. I think is a great idea and would be useful for many powerful applications. Please keep me (us) posted on this. Would this go natively inside SQLite engine? Vivek >-Original Message

[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: T

[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 tradeof

[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] SQLite for CAD database

Hello- Has anyone used SQLite database for storing CAD database: especially netlist and physical connectivity/topology? If so, what kind of performance have you been able to get? Rajan

[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 multiple

RE: [sqlite] Re: Re: in memory SQLite in C/C++

Thursday, October 20, 2005 3:22 PM >To: SQLite >Subject: [sqlite] Re: Re: in memory SQLite in C/C++ > >Rajan, Vivek K wrote: >> One question: So at any given point in time, one can only have _ONE_ >> SQLite database in-memory? > >If I understand it correctly, every s

RE: [sqlite] Re: in memory SQLite in C/C++

y SQLite in C/C++ > >Rajan, Vivek K wrote: >> As I understand it is possible to us in-memory SQLite database. Does >> someone have example C/C++ code to demonstrate techniques for using >> in-memory SQLite database? > >You use sqlite3_open to open a database with a spec

[sqlite] in memory SQLite in C/C++

Hello- As I understand it is possible to us in-memory SQLite database. Does someone have example C/C++ code to demonstrate techniques for using in-memory SQLite database? Thanks in advance. Rajan

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

swer >> 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; std

[sqlite] sqlite and spatial extension

Hello- Are there spatial extensions available for sqlite? And/or is there any add-on library/shareware/freeware which can enable spatial extensions/queries with SQLite? Rajan

[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] How to load a SQLite schema from file using SQLite C-API

I have SQLite schema in an ascii file. I would like to be able to load this schema via SQLite C-API. How do I do this? 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 el

[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. An