Re: [sqlite] Recommended (Windows/Linux) SQLite utilities
On Tue, Apr 29, 2008 at 10:10 PM, <[EMAIL PROTECTED]> wrote: > P Kishor, > > > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools > > Oops, that's embarrassing! > > Do you have a favorite on this page that you would recommend? > > Thank you, > Malcolm tkSQLite at http://reddog.s35.xrea.com/wiki/TkSQLite.html Tcl script as well as standalone executable binary versions for both Linux and Microsoft Windows. BSD license. Updated frequently, current version wraps SQLite 3.5.7. Robert Wishlaw ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] make import not abort
Paul DiSciascio wrote: > I have a CSV file contains records with a unique randomized ID as the > primary key. I retrieve a copy of the file daily and I don't have > control over when old records are removed from the file. I would like > to simply import this data into a table each day, ignoring the rows > where I've already imported them (i.e. the primary key already exists > in the database); however, if I attempt an import on a CSV file that > contains a row in which the key already exists in the table, I get an > error about uniqueness and none of the rows are imported. Is there a > way to change this behavior, simply ignoring the pieces that fail and > continuing on? > You can't use the shell's .import command to do that directly. You need to use an "insert or ignore" SQL command, but the .insert command is implemented with a normal insert SQL command. You will first to import your data into a temp table with the same column layout as your real table. create temp table t_temp as select * from t_real limit 1; delete from t_temp; Now you can import into the temp table without any conflicts because it is empty. .import Finally you can insert the new records into the main table using an insert or ignore commnad. insert or ignore into t_real select * from t_temp; Any existing records will be retained in t_real, new records will be added. If you want to replace any existing records in t_real you could use an insert or replace instead. insert or replace into t_real select * from t_temp; HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] numRows undefined function?
Hey Ty & all, Yes, rowCount() worked, and thanks for the reference to the podstatement.php page. But why did so much documentation I found on the web use numRows()? What is the difference between the PDOStatement set of functions and the set to which numRows() belongs to? Different versions of SQLite? Thanks again, Skip Ty wrote: > Skip Evans <[EMAIL PROTECTED]> writes: > >> But when it runs I get the following error: >> >> Call to undefined method PDOStatement::numRows() >> >> All the documentation I see on SQLite shows this >> as a valid method. > > > > > If I'm reading correctly, $result is of type PDOStatement. From the > documentation, it doesn't look like numRows is a function on that object... > > http://us.php.net/manual/en/class.pdostatement.php > > I would try $result->rowCount() and see if that gets you what you need. (The > docs for that function claim it doesn't work for all types of databases... I > don't know how it works with sqlite). > > ~Ty > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypenguin.com =-=-=-=-=-=-=-=-=-= Check out PHPenguin, a lightweight and versatile PHP/MySQL, AJAX & DHTML development framework. http://phpenguin.bigskypenguin.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] numRows undefined function?
Skip Evans <[EMAIL PROTECTED]> writes: > But when it runs I get the following error: > > Call to undefined method PDOStatement::numRows() > > All the documentation I see on SQLite shows this > as a valid method. If I'm reading correctly, $result is of type PDOStatement. From the documentation, it doesn't look like numRows is a function on that object... http://us.php.net/manual/en/class.pdostatement.php I would try $result->rowCount() and see if that gets you what you need. (The docs for that function claim it doesn't work for all types of databases... I don't know how it works with sqlite). ~Ty ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] make import not abort
I have a CSV file contains records with a unique randomized ID as the primary key. I retrieve a copy of the file daily and I don't have control over when old records are removed from the file. I would like to simply import this data into a table each day, ignoring the rows where I've already imported them (i.e. the primary key already exists in the database); however, if I attempt an import on a CSV file that contains a row in which the key already exists in the table, I get an error about uniqueness and none of the rows are imported. Is there a way to change this behavior, simply ignoring the pieces that fail and continuing on? Thanks, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] numRows undefined function?
Hey all,
I'm new to the list and SQLite, although I have
about 7 years with MySQL, and going back to Oracle
and Informix a rock's age with databases.
I have the following code in a PHP 5.2.5 install.
$sql="SELECT * FROM bsp_model WHERE makeID=$makeID
ORDER BY model";
$result = $dbHandle->query($sql);
// if 0 records returned, reload drop down with
empty, single selection.
$norows=$result->numRows();
if ($norows==0)
{
echo 'false';
exit;
}
But when it runs I get the following error:
Call to undefined method PDOStatement::numRows()
All the documentation I see on SQLite shows this
as a valid method.
I know that $result is a valid DB object
containing data because if I simply comment out
the test for zero records everything works fine
(because there is data in the object), but I still
need the test for zero records.
Any suggestions would be greatly appreciated.
Skip
--
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX & DHTML development framework.
http://phpenguin.bigskypenguin.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
Regarding: I think you're right for general purpose applications. But if you have ETL or data conversion/analysis applications that can be re-run after a failure (using source content), this type of pragma sounds like a reasonable choice. Malcolm === Hi Malcolm, I very much agree with your statement -- I turn it off sometimes myself to good effect. But the webpage will be read by all sorts of users, and there was not a mention of the conditions under which this would be wise or foolhardy. A newbie might well turn off synchronous inappropriately, take an application to production, then lose all her data. It just seems (to me at least) quite unfriendly not to include a warning when suggesting synchronous=OFF. Your mileage may vary. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] splite database under version control (subversion)?
Dear Sqlite users, I want to put a sqlite database under version control (in my case subversion). As far as I know the sqlite database is a binary file. Always exporting and importing the database to a sql file is quite laborious . What is the standard approach for this ? Is there any "filter" available for subversion which does the conversion automatically? Thanks Emal -- GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
Donald, > http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas > > Am I right in that the article above promotes the use of "PRAGMA > synchronous=OFF" without even a TRACE of warning that this may result in irretrievable database corruption? Isn't that a bit reckless? I think you're right for general purpose applications. But if you have ETL or data conversion/analysis applications that can be re-run after a failure (using source content), this type of pragma sounds like a reasonable choice. Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
Regarding the article at: > http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas Am I right in that the article above promotes the use of "PRAGMA synchronous=OFF" without even a TRACE of warning that this may result in irretrievable database corruption? Isn't that a bit reckless? Excerpt: = 2.2 PRAGMA synchronous The Boolean synchronous value controls whether or not the library will wait for disk writes to be fully written to disk before continuing. This setting can be different from the default_synchronous value loaded from the database. In typical use the library may spend a lot of time just waiting on the file system. Setting "PRAGMA synchronous=OFF" can make a major speed difference. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] how is sqlitedll-3.5.8.zip built?
On Apr 30, 2008, at 3:29 PM, Dennis Cote wrote: > Richard (or anyone else who knows), > > I am looking at ticket 3084, and I am seeing a difference in behavior > between using the DLL and the amalgamation source with the exact same > test application. The script used to build the DLL found on the website is http://www.sqlite.org/cvstrac/fileview?f=sqlite/mkdll.sh&v=1.14 It is cross-compiled from a Linux host using a 5-year-old build of mingw. > > > I was under the impression that the DLL available for download is now > built from the amalgamation. Is that correct? If so, what options are > defined when it is being built? If not, how is it built? > > TIA > Dennis Cote > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] how is sqlitedll-3.5.8.zip built?
Richard (or anyone else who knows), I am looking at ticket 3084, and I am seeing a difference in behavior between using the DLL and the amalgamation source with the exact same test application. I was under the impression that the DLL available for download is now built from the amalgamation. Is that correct? If so, what options are defined when it is being built? If not, how is it built? TIA Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
> But my advice stands. Set things up and see how things work. If you want/need > better performance, start tweaking. But there is a good chance that the > performance "out of the box" will be fine. Thanks Gerry! Regards, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
[EMAIL PROTECTED] wrote: > Hi Gerry, > > >> Much care and thought have gone into setting up the default behaviors in >> SQLite. >> My advice would be not to use any pragmas initially. >> > > That may be the safe solution, but my impression was that SQLite > defaults to conservative settings that may not apply to many of today's > high RAM workstations. > > Since I asked my question, I came across the following article that > suggests 4 common pragma opportunities for optimization. The article is > from 2006 so I don't know if its advice still applies to the current > version of SQLite. > > http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas > > The statement below from that article makes it clear that the information in the article was not up-to-date even in 2006: /(This PRAGMA is not fully implemented, as of 2.8.6.) / Versions 2.8.15 and 3.0.3 date back to July 2004, and 2.8.6 is from August 2003. There is no doubt that pragmas can improve performance for lots of different circumstances. Limited RAM, lots of RAM, among many possibilities. Knowing about the kinds of things that can be done is a Good Thing. But my advice stands. Set things up and see how things work. If you want/need better performance, start tweaking. But there is a good chance that the performance "out of the box" will be fine. Gerry ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] FTS search negative term syntax
Scott Hess wrote: > It's not entirely clear that the fts search syntax should aim to hew too > closely to consumer-oriented search syntax. Indeed, I would expect the FTS search syntax to optimize for the machine model, while the user-facing syntax optimizes for human comprehensibility, and the application takes responsibility for translating one to the other. -myk ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] FTS search negative term syntax
Interesting point. This seems like the kind of thing that could be
implemented in the existing fts codebase without involving a version
change. It also may be more general than just hyphenated words, for
instance $12.50 might be more usefully translated as the phrase search
"12 50" than all documents which contain 12 and 50 anywhere. I bet
five minutes of thought would result in 25 other examples, just in
English.
Fair warning, though: It's not entirely clear that the fts search
syntax should aim to hew too closely to consumer-oriented search
syntax. It's sort of in a strange place, most people would think it a
poor idea (indeed, dangerous!) to put user-entered expressions in
their WHERE clauses. In other search systems you might have an API
for constructing query trees which you would pass in, but that may be
weird to express via SQL. Not sure where this pretty muddy point
leaves us, because it's probably not relevant to this specific case
:-).
Caveat for the above: I've spent all of five minutes thinking about
your posting, and I was interrupted in the middle. But I'll try to
factor it in to future thinking.
Thanks,
scott
On Wed, Apr 30, 2008 at 8:58 AM, Ralf Junker <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a small concern about the FTS negative term search syntax. Currently,
> all terms following any minus sign ("-") are excluded from the search. This
> is a very welcome feature, but consider searching for these hyphenated words:
>
> Coca-Cola -> FTS finds Coca, but never Cola
> low-budget -> FTS finds low, but never budget
> twelve-year-old -> FTS finds twelve, but never year and never old
> part-time -> FTS finds part, but never time
> full-time -> FTS finds full, but never time
>
> These results do not match what most users will expect. Well, one can ask
> them to leave out the minus sign, but users will habitually leave it in
> because they learned from major search engines that it is the intended
> behavior. Consider Google, which explicitly states:
>
> "Note: when you include a negative term in your search, be sure to include a
> space before the minus sign."
>
> Source:
> http://www.google.com/support/bin/static.py?page=searchguides.html&ctx=basics
>
> Therefore I would like to consider adding these search syntax rules:
>
> 1. A minus sign excludes a search term only when located at the beginning of
> the search query or after a white space (space, tab, etc.):
>
> "low-budget" -> Find both low and budet.
> "low -budget" -> Find low, but not budget.
> "-low budget" -> Do not find low, but find budget.
> "-low-budget" -> Do not find the "low budget" phrase.
>
> 2. In case the minus sign is a term separator and two or more search terms
> are separated by sisngle minus signs only, they constitue a phrase search:
>
> "twelve-year-old" -> "twelve year old" (phrase search)
> "part-time" -> "part time" (phrase search)
>
> I believe that these changes would make the FTS search syntax more intuitive
> to use and more conformant to major search engines.
>
> Would there be a chance that they could be implemented in current FTS3 and/or
> the upcomming FTS4?
>
> Any thoughts?
>
> Ralf
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended (Windows/Linux) SQLite utilities
I've had good luck with Mike Cariotoglou's free Sqlite3Explorer http://www.singular.gr/sqlite/ I especially like being able execute just the sql command that I've highlighted. Some other interesting features: --Access-ish query designer (if you like that sort of thing) --Integrated with to a report generator module. --Import using regular expression (simple example at http://readlist.com/lists/sqlite.org/sqlite-users/1/9231.html ) This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
Hi Gerry, > Much care and thought have gone into setting up the default behaviors in > SQLite. > My advice would be not to use any pragmas initially. That may be the safe solution, but my impression was that SQLite defaults to conservative settings that may not apply to many of today's high RAM workstations. Since I asked my question, I came across the following article that suggests 4 common pragma opportunities for optimization. The article is from 2006 so I don't know if its advice still applies to the current version of SQLite. http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas Regards, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] One connection with 2 statement handle.
Have anyone had experience about one connection with multiple statement handle: one for selection and one for deletion. Is there any problem in this case. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Monday, April 28, 2008 9:31:17 AM Subject: Re: [sqlite] One connection with 2 statement handle. I would like to clarify on this locking. So if I have one connection and mulitiple statements then there is no locks in this cases regardless what are the statement operations. Thanks, JP - Original Message From: Alex Katebi <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Monday, April 28, 2008 8:44:02 AM Subject: Re: [sqlite] One connection with 2 statement handle. Does this mean that if I have one connection and multiple statements operating on a in-memory table within a single thread no statement will lock out another? In other words locks will not be used? On Sat, Apr 26, 2008 at 7:40 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi, > One connection(sqlite3 *pDb) uses by multiple statements > handle(sqlite3_stmt). > So one connection is used by two multiple statements concurrently one for > insertion and one for selection. Is that ok. > > Have any one experienced this situation. > Thanks, > JP > > > > > > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended pragmas for new SQLite users to focus on
[EMAIL PROTECTED] wrote: > I'm new to SQLite and have been reading the archives for background. > > Are there a common set of pragmas that a new developer should master and > if so which ones do you recommend I focus on? > > Is there a 'best practice' standard set of pragmas that apply to most > applications? Much care and thought have gone into setting up the default behaviors in SQLite. My advice would be not to use any pragmas initially. If you find that you need better performance or different behavior, start tweaking then. Of course, you will need to read through the documentation a few times to be aware of the possibilities. (It sounds as if you have been doing this already, and should be in good shape.) To rephrase, the standard set of pragmas is the empty set. SQLite "just works." Good luck, Gerry ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] FTS search negative term syntax
Hello,
I have a small concern about the FTS negative term search syntax. Currently,
all terms following any minus sign ("-") are excluded from the search. This is
a very welcome feature, but consider searching for these hyphenated words:
Coca-Cola -> FTS finds Coca, but never Cola
low-budget -> FTS finds low, but never budget
twelve-year-old -> FTS finds twelve, but never year and never old
part-time -> FTS finds part, but never time
full-time -> FTS finds full, but never time
These results do not match what most users will expect. Well, one can ask them
to leave out the minus sign, but users will habitually leave it in because they
learned from major search engines that it is the intended behavior. Consider
Google, which explicitly states:
"Note: when you include a negative term in your search, be sure to include a
space before the minus sign."
Source:
http://www.google.com/support/bin/static.py?page=searchguides.html&ctx=basics
Therefore I would like to consider adding these search syntax rules:
1. A minus sign excludes a search term only when located at the beginning of
the search query or after a white space (space, tab, etc.):
"low-budget" -> Find both low and budet.
"low -budget" -> Find low, but not budget.
"-low budget" -> Do not find low, but find budget.
"-low-budget" -> Do not find the "low budget" phrase.
2. In case the minus sign is a term separator and two or more search terms are
separated by sisngle minus signs only, they constitue a phrase search:
"twelve-year-old" -> "twelve year old" (phrase search)
"part-time" -> "part time" (phrase search)
I believe that these changes would make the FTS search syntax more intuitive to
use and more conformant to major search engines.
Would there be a chance that they could be implemented in current FTS3 and/or
the upcomming FTS4?
Any thoughts?
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended (Windows/Linux) SQLite utilities
Hi Dennis, > On Windows I like SQLiteSpy from > http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index > For cross platform use (Mac, Windows, and Linux) you may be interested > in the SQLite Manager add-on for Firefox at > https://addons.mozilla.org/en-US/firefox/addon/5817. Thanks for your recommendations. I've been plodding through all the choices and SQLiteSpy looks like the best so far. The SQLite Manager FireFox add-on is new to me. I'll check it out. Regards, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Recommended (Windows/Linux) SQLite utilities
[EMAIL PROTECTED] wrote: > > Do you have a favorite on this page that you would recommend? > On Windows I like SQLiteSpy from http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index For cross platform use (Mac, Windows, and Linux) you may be interested in the SQLite Manager add-on for Firefox at https://addons.mozilla.org/en-US/firefox/addon/5817. It seems to work quite well in my testing. Its nice to have the same interface on multiple platforms if you switch back and forth often. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Authorize Functions Too Coarse
I have an embedded application that uses a single :memory: database connection. This application has a user interface via a networking socket that receives SQL commands. The application tasks and the user interface will use the single :memory: connection. I want to limit the user interface for access. Unfortunately the Authorise Functions are tied to the database connections rather than statements. Basically the application tasks should be able to do anything and user interface task to be limited. Since I am running in-memory database, the Authorization Functions do not give me the differentiation that I need. Thanks, -Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing sqlite
If you have TCL installed, you can build the 'testfixture' which is used to run the tests. ;# Unpack the source tree into "sqlite" mkdir sqlite cd sqlite tar xzf sqlite.tar.gz ;# Build will occur in a sibling directory cd .. mkdir bld ;# Change to the build directory cd bld ;# Run the configure script (this generates makefile in bld directory) ../sqlite/configure ;# Run the makefile. make ;# Make the testfixture and run fulltest suite make fulltest You can run individual tests by running the testfixture directly and specifying the test you want to run: testfixture ../sqlite/test/alter.test On 4/30/08, Lloyd <[EMAIL PROTECTED]> wrote: > > Hi, > In the test folder of sqlite3 source distribution I saw so many test > scripts. How can I run these tests? I am curious to know the various > testing methods used in sqlite. > > Thanks, > Lloyd > > > __ > Scanned and protected by Email scanner > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Testing sqlite
Hi, In the test folder of sqlite3 source distribution I saw so many test scripts. How can I run these tests? I am curious to know the various testing methods used in sqlite. Thanks, Lloyd __ Scanned and protected by Email scanner ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6
Just open the file. palmer ristevski wrote: > I am new to this type of Forum.Here is my question : My development platform > is VB6. I am using "SQLitePlus COM-DLL" from ez-tools.com.They have code to > access and query an existing ".db" file, but I wish to know how to make a > function call to create new SQLite database files on harddisk.How would you > do this using VB6?What is the function call that you would have to make.I > know how to do this with SQLite at the command line, and I could use VB6 to > execute these commands at the command line, but I want a more direct way to > create new database files.Hope someone can help me out. > Pablopico> Date: Tue, 29 Apr 2008 20:32:32 +0200> From: [EMAIL PROTECTED]> > To: [EMAIL PROTECTED]> Subject: Re: Hello I am a newbie> > Hello Pablopico,> > > i am sorry, but i can not answer your question. I do not know VB. How > did > you find my eMail - address anyway?> > To join the sqlite mailing list, > visit> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > and > follow the instructions. Then post your questions by mailing them to> > > sqlite-users@sqlite.org> > Good luck,> Martin> > [EMAIL PROTECTED] wrote:> > > I am new to this type of Forum.> > I don't know how one is supposed to post > to this forum.> > I don't see a "POST" button on this site.> > Based on email > information I got from SQLite users, is this> > all done via 'email > posting'?> >> > Anyways, I also have a question.> > My development platform > is VB6. I am using "SQLitePlus COM-DLL" from > > ez-tools.com.> > They have > code to access and query an existing ".db" file, but I wish to know how to make a function call to create new SQLite database files on harddisk.> > How would you do this using VB6?> > What is the function call that you would have to make.> > I know how to do this with SQLite at the command line, and I could use VB6 to execute these commands at the command line, but I want a more direct way to create new database files.> >> > Hope you can help me out.> >> > Pablopico> >> >> > > > _ > Back to work after baby–how do you know when you’re ready? > http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite full text speed
Run a trial, but I am sure that fgrep will be faster. Scott Baker wrote: > I'm curious about the speed trade off between a full table scan and just a > flat file search... Say I have a database with 2 records in it. If I do > a query like: > > SELECT foo FROM table WHERE bar LIKE '%glaven%'; > > That will be a full text scan across the table. Would that be any faster > than just a regexp against a flat text file? Obviously you get the > advantages of SQL were it in a DB, versus a flat file. What other trade > offs are there? > > My experience the above, is that in SQLITE it's still incredibly fast. > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
