Re: [sqlite] load regexp noninteractive

http://mailliststock.wordpress.com/2007/03/01/sqlite-examples-with-bash-perl-and-python/ -- no, your example was best for me because DBI is not available in my case. the pure call by system() is what i need. i just needed the hint, not a full solution because this depends on conditions and

Re: [sqlite] Curious SQLite performance observation

Sure looks like cache to me. In your slow version you're walking thriugh the entire table twice as opposed to interleaving. You don't say how big your database is. Increasing cache size may solve the problem. pragma cache_size=2000 (default cache size in pages...1024 size pages means

Re: [sqlite] load regexp noninteractive

Next time write: "I want it for Perl". why? your answer would be the same if we talk about running a shellcommand? the scripting language which runs the call should be irrelevant... not? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Curious SQLite performance observation

This isn't a question as much as an observation that might be interesting for others, too, though I'd share. Having a table building a tree by each item referencing its parent:       // Table Items       CREATE TABLE [Items] (         [iRowID] INTEGER PRIMARY KEY,          [iParentRowID]

Re: [sqlite] SegV at sqlite3_open() (Was: Re: How to sort within a text field)

> Or is there some other init function that can be called to maintain it in > one file? I don't know about that. However, I can see two approaches you could use to keep them in the same file: (1) Since your main is at the bottom of the file, right before it (just after #ifdef MAIN, say), add

Re: [sqlite] load regexp noninteractive

2012/1/5, Hajo Locke : > Hello, > thanks, 2nd is working. > i do in perl now something like: Next time write: "I want it for Perl". -- Kit ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How to sort within a text field

Along with the sortprds code and database I sent out previously this now works. gcc -g -o main main.c -DSQLITE_ENABLE_LOAD_EXTENSION sqlite3.c -lpthread -ldl ./main test.db "select id,sortprds(prdtype) from a order by sortprds(prdtype)" ID = 2 sortprds(prdtype) = 3|10|15|27 ID =

Re: [sqlite] SegV at sqlite3_open() (Was: Re: How to sort within a text field)

Yup...putting the main in a separate file fixed it. Thanks. Or is there some other init function that can be called to maintain it in one file? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information

Re: [sqlite] load regexp noninteractive

Hello, thanks, 2nd is working. i do in perl now something like: $exe="/usr/bin/sqlite3 mydb.db <- Original Message - From: "Kit" To: "General Discussion of SQLite Database" Sent: Thursday, January 05, 2012 1:11 PM Subject: Re: [sqlite]

Re: [sqlite] load regexp noninteractive

echo "select * from a where field1 REGEXP '$foo';" | /usr/bin/sqlite3 mydb.db /usr/bin/sqlite3 mydb.db <: > Hello List, > > i use sqlite 3.6.22 Ubuntu 10.04 > > I want to use REGEXP in my queries but dont find a way to load the lib in > noninteractive Mode. > There is no -load Parameter for

[sqlite] ANN: SQLite PHP Generator 11.12 released

Hi! SQL Maestro Group announces the release of SQLite PHP Generator 11.12, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite

[sqlite] load regexp noninteractive

Hello List, i use sqlite 3.6.22 Ubuntu 10.04 I want to use REGEXP in my queries but dont find a way to load the lib in noninteractive Mode. There is no -load Parameter for sqlite3 Binary. I tried to give 2 commands separated by ; in sql-query but this also dont works. All i want to do is to

Re: [sqlite] retrieve data from movie sqlite database

On 05/01/2012, at 2:21 AM, Petite Abeille wrote: > And the where clause. > > And perhaps add an explicit group by. Quite right. I should have tested. However, using a group by gets a bit inefficient since (as I understand it) SQLite will process the entire select before applying the where