Re: [sqlite] Most wanted features of SQLite ?

P Kishor wrote: > On Sat, Sep 19, 2009 at 9:21 AM, John Stanton <jo...@viacognis.com> wrote: >> Alexey Pechnikov wrote: >>> Hello! >>> >>> On Saturday 19 September 2009 00:43:18 Noah Hart wrote: >>> >>>> Stored Procedures >>>

Re: [sqlite] Most wanted features of SQLite ?

Alexey Pechnikov wrote: > Hello! > > On Saturday 19 September 2009 18:21:22 John Stanton wrote: >> There is a PL/SQL implementation available and we use Javascript as a >> stored procedure capability in Sqlite. It integrates nicely with WWW >> applications. > >

Re: [sqlite] Most wanted features of SQLite ?

Alexey Pechnikov wrote: > Hello! > > On Saturday 19 September 2009 00:43:18 Noah Hart wrote: > >> Stored Procedures >> > > There are Tiny C compiler extension and realization of > stored procedures for SQLite 2 and Lua extension and other. > So you can use one or all of these. > > Best

Re: [sqlite] AIX performance

What machine runs AIX and what machine runs Linux and what FS are you using on Linux? Ken wrote: > Im looking for some ideas as to why the performance for a select statement > takes roughly 5 times longer on AIX as on a linux system. > > The disk drive on the aix platform is a 10k scsi vs the

Re: [sqlite] SQLJet - pure Java implementation of SQLite

way to his door! Shortly after that > Datapoint was no more and his market evaporated. > > Sorry, this ain't SQLite at all. I'm done here. > > Fred > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org]on Behalf

Re: [sqlite] SQLJet - pure Java implementation of SQLite

In this situation it has been our approach to never try to translate source in one language into another. It is a pointlesss activity when you think about it. Much better to have the C or whatever compiler have a different code generator, for example Java target code. You are not rev locked

Re: [sqlite] Merging blobs on disk without taking up memory???

If you map each BLOB into virtual memory and create an anonymous mapped file to receive the concatentaed result toy can handle the blobs without using your stack and heap memory. Of course this assumes that you are using a POSIX OS (e.g. Windows or Unix/Linux). sorka wrote: > Hi. I have a

Re: [sqlite] ANN: SQLite 3.6.16.C#

Maybe the author could explain the reason for C# translation. Surely a better approach if the JIT is required would be to use something like gcc and change the code generator to the C# metacode. Such a product may already exist. A translated program is rev locked. Kosenko Max wrote: > Seems

Re: [sqlite] DATETIME and storage type

Sqlite does not have a DATETIME type. It stores the decalred type but ignored it. You can use it in your application. Rael Bauer wrote: > Hi, > > If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table > "notes" add column "last_modified" DATETIME default "2001-01-01";)

Re: [sqlite] Updating a database by email

Bruce Robertson wrote: >> We use a system of updating an Sqlite database buit use port 80 to send >> data in XML format. >> >> Is there a reason you have access to the email port and not the HTTP >> port 80? It is very complex to identify a missing email but using port >> 80 and HTTP the process

Re: [sqlite] Updating a database by email

We use a system of updating an Sqlite database buit use port 80 to send data in XML format. Is there a reason you have access to the email port and not the HTTP port 80? It is very complex to identify a missing email but using port 80 and HTTP the process is almost trivial Our system

Re: [sqlite] general question

For searching text files grep can be very handy. A regular expression is powerful. Jay A. Kreibich wrote: > On Wed, Jul 08, 2009 at 11:53:13AM +0100, Simon Slavin scratched on the wall: > >> On 8 Jul 2009, at 11:40am, _h_ wrote: >> >> >>> Does any mechanism is available via which I can

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

t;> >>> I tried doing this, but very early into the copy Windows issues the >>> following error: >>> >>> Errror 0x80070021: The process cannot access the file because another >>> process has locked a portion of the file. >>> >>&

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

rror: > > Errror 0x80070021: The process cannot access the file because another > process has locked a portion of the file. > > > On Tue, Jul 7, 2009 at 1:03 PM, John Stanton<jo...@viacognis.com> wrote: > >> You should synchronize your backup (copy). Try surrounding i

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

You should synchronize your backup (copy). Try surrounding it with an exclusive transaction. Stan Bielski wrote: > Sorry for the repost, but the original thread was hijacked by another > list user. This is a serious problem IMHO; it looks like the DB can't > be backed-up without rendering the

Re: [sqlite] very large SQLite tables

dditional significant benefit. Hashtables can be faster in > case you don't need range operations, but placing hash on top of B-Tree to > eleminate single b-tree page shouldn't give any speedup. > > If you have proven that this trick still works - I will be glad to see code > sample wi

Re: [sqlite] very large SQLite tables

I'd like to > see that. > > My another addition to proposal is to use SSD with as small as possible > average access time. Some of them can easily do 50-100x faster. And that > will give 20-50x times faster inserts. > > Thank you. > Max. > > > John Stanton-3 w

Re: [sqlite] very large SQLite tables

: > John Stanton-3 wrote: > >> Why would it not work? It is just adding an extra top level to the >> index. A tried and true method. >> > > It will work. But won't give performance benefit. And from my undestanding > it will even slow down things. > You c

Re: [sqlite] very large SQLite tables

Why would it not work? It is just adding an extra top level to the index. A tried and true method. Kosenko Max wrote: > Have you ever tested such proposal? > I believe that doesn't works. > > > Doug Fajardo wrote: > >> One approach might be to split the big, monolithic table into some

Re: [sqlite] Tips to access SQLite with multiple clients?

Sqlite is NOT a server, it is a library which is linked into an application. It is not a repl;acement for Oracle, DB2, PostgreSQL etc, but is a replacement for local file reads and writes. Sqlite shines embedded in applications like Firefox, various Adobe products for example. Gilles

Re: [sqlite] Database inserts gradually slowing down

Jay A. Kreibich wrote: > On Wed, Jun 17, 2009 at 11:52:45AM +1000, John Machin scratched on the wall: > >> On 17/06/2009 6:17 AM, Hoover, Jeffrey wrote: >> >> >>> One other note, if you have a primary key whose value is continually >>> increasing your pk index can become imbalanced and

Re: [sqlite] Advice on which to use (SQLite or SQL Server) for the following app.

Aqlite is not the DB for your application. You need a server like PostgreSQL or Oracle. Robel Girma wrote: > Hello, > > I am in need for a database to hold a couple of tables with max 10,000 rows > each that I will update frequently and query frequently. > > Example, 5000 users connect to our

Re: [sqlite] Direct row insert from C (without SQL) / Database speed

Use sqlite prepare and bind. Mark Flipphi wrote: > I'm new in using SQLite and have some questions before I start > implementing the SQL lite in a project. > > Is there a way to insert a row of data into a table without having to > convert the data to SQL ? > I need to store 1024 point into a

Re: [sqlite] synchronizing sqlite local data base to a remote data base

I missed the mssql reference. Disregard my suggestion to copy files. You could log the SQL used to modify the DBs and pass it between DBs...Updating Sqlite would require a daemon for real time operation. Simon Slavin wrote: > On 8 Jun 2009, at 7:30pm, Mohey Eldin Hamdy wrote: > > >> I am

Re: [sqlite] synchronizing sqlite local data base to a remote data base

An SQL database is just a file. A copy will sync it, and so will a process like rsync. Real time synchronization requires that you implement some form of daemon. Mohey Eldin Hamdy wrote: > Hey got a question, > > I am trying to synchronize an sqlite local data base with a remote mssql > data

Re: [sqlite] Slow Transaction Speed?

We are happy with the results using JFS on AIX and SUSE Linux. Also no concerns with EXT3 on various Linuxes. We have learned to avoid Windows. Christian Smith wrote: > On Wed, May 27, 2009 at 08:05:00AM -0400, pyt...@bdurham.com wrote: > >> >> In your experience, which Linux file system(s)

Re: [sqlite] Importing text file of numbers into INTEGER PRIMARY KEY aka rowid

It looks as if one of your test fields is not formatted as a valid nteger or is pperhaps a duplicate. Try initially loading your data into a table with a column specified as a real number and not defined as the primary key. If it succeeds use the table to search for duplicates and non-integer

Re: [sqlite] sqlite programmed in C++ ...

ongly believe that the persons are essential, more than the programming > language > > Cheers, > Sylvain > > On Wed, Jun 3, 2009 at 11:53 PM, Rob Sciuk <r...@controlq.com> wrote: > > >> John Stanton wrote: >> >>> This is something of a digression

Re: [sqlite] sqlite programmed in C++

Indeed. Very good reply. > To Sylvain, once again: speculating on what went into the minds of the > developers, when they set out to develop SQLite, they chose the best, > most concise, most portable, most universally compilable, mother of > almost all languages. Once they developed something that

Re: [sqlite] Db design question (so. like a tree)

Something to investigate is to use an AVL tree structure with rowids as the pointers. It would stay balanced and you could present family trees quite simply as well as use SQL to extract data on individuals and sets of individuals. Jay A. Kreibich wrote: > On Tue, Jun 02, 2009 at 11:16:20PM

Re: [sqlite] sqlite programmed in C++

; was it for a performance issue? > or a compiler issue? > or anything else? > > I just read the Linus Torvalds comment on the C++ for Git > What do you think? > > Cheers, > Sylvain > > On Tue, Jun 2, 2009 at 6:16 PM, John Stanton <jo...@viacognis.com>

Re: [sqlite] sqlite programmed in C++

Why wuld you want to do such a thing? Sylvain Pointeau wrote: > Hello, > I would like to know if someone already though about to introduce C++ in > SQLite? > I just think about a minimal subset of C++ that will not make any > performance penalty > (like C with classes) > > is it a performance

Re: [sqlite] Populating dyadic dataset

You might consider using a composite key "1963 CAN ABB" when you design your data structure. Igor Tandetnik wrote: > Vincent Arel > wrote: > >> I'm very, very new to SQLite, and would appreciate any help I can get. >> >> I have 3 long vectors that look like this: >>

Re: [sqlite] Slow Transaction Speed?

Simon Slavin wrote: > On 31 May 2009, at 11:56pm, John Stanton wrote: > > >> Try studying basic database theory and technology to get a better >> understanding of the problem. >> > > I have a pretty good understanding, I think. Plus 25 years experience. &g

Re: [sqlite] Slow Transaction Speed?

Try studying basic database theory and technology to get a better understanding of the problem. You will then understand the reason for absolute transactional integrity and why Sqlite must use fsync or similar and expects fsync to be a complete implementation which ensures that each

Re: [sqlite] Deleting database content : SQLite3 API

gt; > Thanks and Regards, > Souvik > -Original Message- > From: sqlite-users-boun...@sqlite.org on behalf of John Stanton > Sent: Sat 5/30/2009 5:30 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Deleting database content : SQLite3 API >

Re: [sqlite] Deleting database content : SQLite3 API

An Sqlite database is just a file. Delete the file when you start your program and when you open the database Sqlite will create a fresh dne, a very low overhead process.. . souvik.da...@wipro.com wrote: > Hello, > > Please let me know if we have an API in SQLite3 which allows me to >

Re: [sqlite] Feature request

Looks like feature bloat. If you need such features for a particular application just add the code to your application or create a modified version of Sqlite for just that application. It makes no sense to burden all users with overhead for a feature required by only a handful of

Re: [sqlite] Re-try logic on SQLITE_BUSY/deadlocked?

P Kishor wrote: > On Sat, May 23, 2009 at 6:34 AM, Rosemary Alles > wrote: > >> Thanks Simon. I have been leaning that way too - considering switching. >> >> -rosemary. >> >> On May 22, 2009, at 5:55 PM, Simon Slavin wrote: >> >> >>> On 23 May 2009, at 12:10am,

Re: [sqlite] most efficient way to get 1st row

ut that's it. > > http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt > > > > > On Wed, May 20, 2009 at 2:47 PM, John Stanton <jo...@viacognis.com> wrote: > > >> What makes you think that transaction control is not part of SQL-92? >> >&g

Re: [sqlite] most efficient way to get 1st row

Igor Tandetnik wrote: > John Stanton <jo...@viacognis.com> wrote: > >> Shane Harrelson wrote: >> >>> Additionally, it's important to note that the LIMIT/OFFSET clause is >>> not standard SQL >>> >> What makes

Re: [sqlite] most efficient way to get 1st row

What makes you think that transaction control is not part of SQL-92? If a database engine does not support transaction control it is not a full implementation. Transaction control is at the very heart of effective data management. Shane Harrelson wrote: > Additionally, it's important to

Re: [sqlite] Sqlite as a FIFO buffer?

You should be able to implement a classic circular buffer in SQL and make it a VIEW for easy access. ROWIDs can be the buffer pointers and a second table can store the current values. Allen Fowler wrote: > Hello, > > I have several CGI and cron scripts and that I would like coordinate via a >

Re: [sqlite] About Time Field

Sqlite does not have a TIME type.. It is interpreting your time as an integer or floating point number or maybe text, depending upon its format. Hughman wrote: > Hi, > > I create a table with a field of datatype Time, and when I insert a > formatting string like 'HHMMSS' into it , the first

Re: [sqlite] Prepared statements must be generated inside your transaction

ut just copy the new inserted row to the data structure > that already binded outside of the loop. In this case we don't need to bind > the columns in the loop. Why this way didn't work for SQLite3 database. > Thanks, > JP > > > > > > From: J

Re: [sqlite] Prepared statements must be generated inside your transaction

The confusion is in the names. When you "PREPARE" a statement you actually compile the SQL. Compiling a program each time you run it is a waste of resources, and so is compiling the SQL each time you use it. Prepare your statements once and use them many times, binding data to the compiled

Re: [sqlite] import / insert 120k records

Write a simple program.. As I recall our programs which do this use the Expat parser and obey a protocol where the XML DTD represents the database tables and columns so that SQL can be generated directly from the XML. It makes for a handy way to transport a database, or a part of a database

Re: [sqlite] Optimizing concurrency with sql query - locks?

Sqlite is an ACID database - it ensures that data is written to disk, so a database in memory still shares a single disk resource. Jim Wilcoxson wrote: > I'm not sure what you are considering a massive slowdown, but let's > assume that the entire database fits into memory and disk I/O isn't >

Re: [sqlite] Optimizing concurrency with sql query - locks?

Igor Tandetnik wrote: > "Rosemary Alles" wrote > in message news:af79a266-b697-4924-b304-2b1feccba...@ipac.caltech.edu > >> Run on a single processor, the following query is quite fast: >> >> When concurrency is introduced (simply running the query on several >>

Re: [sqlite] mutex and begin/end transaction

. It should get back to Sqlite. James Gregurich wrote: > I describe reality. > > Someone has to be the arbiter of "better." Generally, that arbiter is > the guy handing out the research grants. > > On May 1, 2009, at 5:33 AM, John Stanton wrote: > >

Re: [sqlite] Errors with quickstart.html's C example

What is your make file? It seems to be missing a link library. Samuel Baldwin wrote: > Howdy. When I try to compile the small C program at the bottom of > http://www.sqlite.org/quickstart.html , I get the following errors: > > arrakis^library% gcc test.c > test.c: In function ‘main’: >

Re: [sqlite] mutex and begin/end transaction

many people create ill conceived programs doesn't mean > threaded programs are inherently doomed to be ill-conceived. The > development tools and techniques for building concurrent systems are > advancing and making concurrency quite feasible. > > James Gregurich > En

Re: [sqlite] mutex and begin/end transaction

I suggest that you peruse the source code of Pthreads to get some idea of what you do when you create a thread. They are not, as some people appear to believe, a magic way of making the machine do more and go faster. Threads are of course invaluable when you want one resource, such as a user,

Re: [sqlite] mutex and begin/end transaction

A "position" is politics, not science. Warnings about the use of threads are based on science, and advise you to avoid them if possible for your own protection. I see ill conceived programs using threads which go to complex synchronization to achieve the equivalent of single stream execution

Re: [sqlite] Sporadic freezes of sqlite

Sqlite does not use a server. It is embedded in the application. Pavel Ivanov wrote: > Unfortunately these two options are not for me. > I'm not in control of servers hardware, so my application should work > on the given servers and nobody will adjust them for my application. > And about first

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

P Kishor wrote: > On Fri, Apr 24, 2009 at 5:27 AM, John Stanton <jo...@viacognis.com> wrote: > >> Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by >> without the advanced features of Sqlite, then use Berkely and take >> advantage of its s

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by without the advanced features of Sqlite, then use Berkely and take advantage of its simplicity and faster execution. Note that for best performance an Sqlite application should group database inserts, deletes and updates

Re: [sqlite] Creating procedures in sqlite

Sqlite does not have stored procedures, but does have functions. We iplemented Javascript as a stored procedure language in Sqlite and are currently looking at doing the same with Python for another application. You could also use Lua. These are all Open Source projects. Jyoti Seth wrote: >

Re: [sqlite] Transaction commit performance

COMMIT does the heavy lifting, which is why it consumes resources. It actualy performs the safe write to the disk. Alessandro Merolli wrote: > Hi all, > >I'm working on a project that makes massively usage of SQL > statements with many inserts/selects. It's a multi-threaded process >

Re: [sqlite] Sporadic freezes of sqlite

Running in an unsafe mode for speed does not mean that ultimately there will have to be no writes, Perhaps you could devise a system where you post writes to a queue and have another thread or process perform the writes asynchronously. You would then use otherwise idle machine time for

Re: [sqlite] Select statements in the context of transactions.

A TRANSACTION only has a meaning when the database is being altered. There are no journalling and commits on a read. You get the results of the SELECT as soon as the database read occurs. You cannot be faster than that. Where you can get improved SELECT performance is by using caching.

Re: [sqlite] httpd server ???

processes with minimum overheads. Should you have an interest in examining or using all or part of this software contact me at jo...@viacognis.com and I can make a URLavailable. JS dcharno wrote: > John Stanton wrote: > >> I have an HTTP server wj\hich embeds Sqlite as well as a

Re: [sqlite] httpd server ???

I have an HTTP server wj\hich embeds Sqlite as well as a custom page generation language, and compiler and a remote procedure call interface for AJAX functionality and Javascript as an embedded scripting language. It runs on Unix/Linux and conditionally compiles for Windows. It uses a

Re: [sqlite] DateTime Objects

Look at the Sqlite sourcce code in the date function area and all, is revealed. jonwood wrote: > John Stanton-3 wrote: > >> Use the Sqlite date storage format and support. With that approach >> which is astronomivally correct you can deliver any date format or >>

Re: [sqlite] DateTime Objects

Use the Sqlite date storage format and support. With that approach which is astronomivally correct you can deliver any date format or manipulwtion, You may need some custom written functions. to get week number according to national rules etc, but the method is sound. It is also compatible

Re: [sqlite] Maximum number of concurrent users

It is an embedded system, so the number of users depends on how it is used. Be aware that it is not a database server like Oracle or DB2, but is a library of routines to link into your application. Eversogood wrote: > Hi, > > What is the maximum number of concurrent users for SQLite? > >

Re: [sqlite] Double entry bookkeeping

BareFeet wrote: > Hi John, > >> You still miss the point of the cross reference ID. It is NOT the >> reference ID od the document, such as an invoice or check number, >> but it >> more like the row ID used by Sqlire as a unique key for a DB row. > > I thought, from your explanation, that was

Re: [sqlite] Double entry bookkeeping

We are talking about different things. The referennce ID is an ID assigned by the originator or the transaction, say an invoice number from a vendor or a check number from a bank whereas the cross reference is assigned by the application software and represents a key in an index on the table.

Re: [sqlite] Any concept of row number in SQLite?

Use the Sqlite row id. His Nerdship wrote: > Hi, > I am converting a program from Paradox (stop laughing, please) to SQLite. > Paradox has a useful feature where you can specify the actual index of a row > in the table. This is handy when the table is displayed in a grid and you > want the

Re: [sqlite] Double entry bookkeeping

You still miss the point of the cross reference ID. It is NOT the reference ID od the document, such as an invoice or check number, but it more like the row ID used by Sqlire as a unique key for a DB row. You could normalize out the date and have stored as associated with the cross reference.

Re: [sqlite] Double entry bookkeeping

"Double Entry" book keeping is actually a misnomer. A transaction is very likely to have more than two entries. The "transaction ID" I mentioned is a locally generated reference ID to tag the particular complete transaction, which might include postings to a bank account, sales, cost of

Re: [sqlite] Double entry bookkeeping

In general you need for one transaction - General Ledger account Date Reference ID Cross Reference Amount Optional narrative The Chart of Accounts defines full set of accounts and the details of each account. The G/L A/C indicates whether it is an asset or liability account (plus or minus) and

Re: [sqlite] Question on missing Entry Point for Sqlite 3

"Ypu can lead a horse to water but you cannot make it drink" . W Allan Edwards wrote: > Hey... 640k memory ought to be enough for everyone! > > Maybe today, but historically > > I thought sqlite was originally designed and developed by Dr. Hipp so he > could learn database technology? (SQL

Re: [sqlite] Question on missing Entry Point for Sqlite 3

You do not appear to understand the intent of Sqlite. It is an open source software library which can be comiled to siuit unique application requirements. Decide what features you want to use and set the conditional compilation flags accordingly and com;pile it to all the platforms you

Re: [sqlite] Group by week

You need a function which gives the week number. Note that this is calculated differently in the USA and Europe., so you need to use the correct rules to write the function. Moshe Sharon wrote: > Hi > > How can I select group by week > > moshe >

Re: [sqlite] Adding Custom Column Data Types

We do thisby usig the Sqlite "Declared Type" (which can be anything you choose) and intercepting it in a layer of software between Sqlite and the application language manager. For example we have a decimal number type, a date type etc. The data is stored as Sqlite TEXT or FLOAT but the

Re: [sqlite] What is the advantage of using native c API over ODBC

You avoid an unecessary layer of software and have better control over the database. goldy wrote: > Hi All, > > What are the basic advantage of using SQLite with C API over ODBC. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] Date datatype

Sqlite has no date type. Use a floating point number and the Sqlite date functions. Add your own ones to get extra functionality. Paolo Pisati wrote: > It seems i'm having an hard time with dates in sqlite: > > sqlite> .schema > CREATE TABLE `envelope` (`smtp_id` int(10) NOT NULL, `date` date

Re: [sqlite] Compressed dump SQLite3 database

A compression program like gzip is not a l"library", it is a free standing, open source program. It has no secrets. vlema...@ausy.org wrote: > Hello, thank you and others for your answers. > > We are not allowed to use external libraries, because of industrial > certification constraints. We

Re: [sqlite] Compressed dump SQLite3 database

Just use something like gzip to make a compressed version of the database for storage. You would most likely save up to 80% of the space. The .gz files are an industry standard for compression. vlema...@ausy.org wrote: > Hello, > > We need to produce copies of our databases for archive. > It

Re: [sqlite] Is this legal SQL?

You can only bind data elemeents. If you want to chjange table names you have to recompile the SQL (think about it). Mike McGonagle wrote: > Hello all, > > I am working on connecting SQLite up to another programming language, > and had a question about how SQLite (or SQL in general) would

Re: [sqlite] Using Eclipse on Windows XP

Alternatively you can install Dev-CPP IDE which automatically activates Mingw and compile Sqlite. schachtobi wrote: > Hi, > > what you need are first Eclipse, the C Development Tools (CDT) and a > compiler for Example the MinGW > > Here are the links for the tools I used for my project. > >

Re: [sqlite] Impossible to declare field type BIGINT PRIMARY KEY

just a > syntax parsing issue in the end. > > Or am I demanding too much? > > regards, > > nat > > Quoting "John Stanton" <jo...@viacognis.com>: > > >> You are still missing something. Apply some deeper thought to the >> concepts be

Re: [sqlite] Impossible to declare field type BIGINT PRIMARY KEY

make life easy for you and don't fight it. You will be rewarded handsomely. Nathan Catlow wrote: > Quoting "John Stanton" <jo...@viacognis.com>: > > >> You have not grasped the fundamental concept of typing used by Sqlite. >> It implements manifest

Re: [sqlite] Impossible to declare field type BIGINT PRIMARY KEY

You have not grasped the fundamental concept of typing used by Sqlite. It implements manifest typeing in the manner of scripting systems like Javascript etc. It has a clever feature which permits you to declare a type as anything you like and parses that name to decide on the underlying

Re: [sqlite] Adding data with periods

Single quotes are SQL, as chosen by he designers. It is good practice to stick to the standard rather than rely on extensions which vary from implementatiopn tio implementation. Mohd Radzi Ibrahim wrote: > It seems to works either way. > > I'm just wondering is there any hidden reason that

Re: [sqlite] Adding data with periods

Note that literal delimiters in SQL are single quotes, e.g. 'This is an SQL literal'. It is good practice with Sqlite to use bound variables. You avoid possible SQL injection attacks and limit sensitivity to data content. aditya siram wrote: > Hi all, > I'm having trouble adding data with

Re: [sqlite] Sqlite replication

It would be a relatively minor job to make Sqlite replicate itself. The partitioning in its design seperates the i/o level. Wade Williams wrote: > I'm looking for an honest assessment from someone that may have made > this decision in the past. > > I'm considering using an embedded database

Re: [sqlite] sqlite database to postgresql

Dump the database as SQL, then execute the SQL with PostgreSQL. Manisha De Silva wrote: > Now that I have a textfile which has a sqlite database can this be added to a > postgresql database? If so how? > This message (and any associated files) is intended only for the use of the > individual to

Re: [sqlite] data dump in sqlite

Open up a command prompt window. Then key sqlite3 That will ring up a command line accessto your Sqlite database. If you want a GUI interface there is a Firefox plugin which interfaces to Sqlite. Try that or one of the very many Sqlite GUI interfaces like Sqlitespy. Manisha De Silva

Re: [sqlite] Deactivation of Manifest Typing

In one of our Sqlite applications the gratuitous type changes of Sqlite were incompatible and it took only a very few patches to the Sqlite source to disable the detection and change code. Clay Dowling wrote: > Simon de Hartog wrote: > >>SQLite has a feature called Manifest typing. As with

Re: [sqlite] SQLite performance woe

es? Is it as simple as creating an indice > per primary key in a table? > > How do I interpret the output from EXPLAIN QUERY PLAN? > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Stanton > Sent: Tuesday, December 02

Re: [sqlite] SQLite performance woe

Databases work by using indices. A search for a row in a table of 1 million rows goes from having to do as many as a million row reads to a handful of index node accesses, from minutes to milliseconds. Note that Sqlite is "lite" and only uses one index at a time so thoughtful schema design

Re: [sqlite] sqlite 3.6.5 slow on windows

Use sqlite3_prepare/bind/step instead of sqlite3_exec and group your activity into BEGIN ... COMMIT transactions. Breeze Meadow wrote: > Hi, > > I found sqlite is kind of slow on windows (2003 server and XP professional). > Here is what i did: > 1) downloaded and installed sqlite3.dll

Re: [sqlite] Two questions

Christophe Leske wrote: >>> Can I spare some bytes in my DB by defining the ID field of the >>> standard >>> table as being a foreign key of the rtree table? In other words, when >>> defining a foreign key, is the coloumn referencing the ID field of the >>> foreign table and thus NOT replicating

Re: [sqlite] Terrible performance for one of our tables

Jens Miltner wrote: > Am 19.11.2008 um 13:05 schrieb D. Richard Hipp: > >> On Nov 19, 2008, at 3:08 AM, Jens Miltner wrote: >> >>> Hi, >>> >>> we're seeing terrible performance problems when fetching data from >>> one >>> of our tables: >>> The table contains roughly 1.2 Million rows and a

Re: [sqlite] Recovery program

Since an Sqlite database is a single file taking a snapshot backup is very simple and rapid. You could maintain an almost current image at all times that way. Complete recovery could be possible by modifying Sqlite oryour application to keep a journal of SQL statements processed between

Re: [sqlite] Escaped values throws error

It is particularly valuable to use bound values when you have WWW access so that you block the possibility of SQL injection attacks. Eric Minbiole wrote: >>This is my first foree into PDO-SQLite and I saw samples using binding, >>I am using prepare() though without binding. >> >>So you think

Re: [sqlite] Escaped values throws error

An SQL literal uses single quotes. Ben Marchbanks wrote: > Abridged sample of the insert statement that produces an error when > trying to insert escaped text. > > > INSERT INTO pageWords (word) VALUES (" \"nitch\" "); > > SQLSTATE[HY000]: General error: 1 near "nitch": syntax error' > >

Re: [sqlite] (no subject)

Everything you want is on www.sqlite.org. If you cannot handle that you probably do not have a use for Sqlite. Satish wrote: > Hi! >Can I get some samples to work on sqlite that is how to create a database > and inserting ... don' t think again I am joking plz help me.it was bit >

  1   2   3   4   5   6   7   8   9   10   >