Hello!
On Friday 27 February 2009 00:44:05 Alan Cohen wrote:
> This is a bit of a religious question, but which are the mest/most
> popular *nix GUIs out there? I'm using a firefox plugin but not
> entirely happy with it. What do you use and why?
I'm prefer tksqlite:
Hello!
On Monday 23 February 2009 23:54:56 pyt...@bdurham.com wrote:
> Are there any plans to enhance SQLite to support some of Oracle's
> parallel processing or partitioning capabilities?
But Oracle does not database for "cloud computing".
You can't get no-installable and no-administrate
Hello!
On Monday 23 February 2009 16:48:09 P Kishor wrote:
> I am tinkering with (aka learning) Xcode 3.1.2, and am trying to set
> up an Xcode project for SQLite amalgamation. What could be simpler,
> no?
Use full SQLite source tree. Amalgamation will be created automatically by
build system.
Hello!
On Monday 23 February 2009 13:09:58 Jérôme Loyet wrote:
> My questions:
> 1- Is there a better way to populate the `siblings` table ? (optimize
> my sql request)
You may use compose index on (cookie,referer,date) and REAL datatype for
dates.
> 2- What can I do to optimize the all
Hello!
On Sunday 22 February 2009 22:56:36 jose isaias cabrera wrote:
> I have left everything default, so I have not set any PRAGMA settings.
Try this:
pragma cache_size=1;
pragma page_size=16384;
vacuum;
Best regards.
___
sqlite-users mailing
Hello!
В сообщении от Wednesday 18 February 2009 01:05:54 Paolo Pisati написал(а):
> > 2. Add NOT NULL constraint to all fields.
> >
> >
>
> what does it buy me?
I think NULL values descrease B-tree indexes performance.
P.S. You can split database for increase summary performance. For example
Hello!
В сообщении от Tuesday 17 February 2009 22:01:38 Jay A. Kreibich написал(а):
> > I think you can to try
> >
> > 1. Replace date date, time time to single REAL field:
> > date REAL NOT NULL DEFAULT (julianday('now'))
>
> That's not going to do what you think it is going to do.
>
>
Hello!
В сообщении от Tuesday 17 February 2009 13:45:34 Paolo Pisati написал(а):
> sqlite> .schema
> CREATE TABLE envelope (
> smtp_id unsigned int(10), date date, time time, mailq_sndr unsigned
> int(10), delivery_sndr unsigned int(10), customer_sndr unsigned int(10),
> rpath
Hello!
В сообщении от Tuesday 17 February 2009 15:01:31 Paolo Pisati написал(а):
> any other hint?
PRAGMA default_cache_size = 20;
pragma page_size=4096;
vacuum;
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello!
В сообщении от Monday 16 February 2009 22:14:03 Jay A. Kreibich написал(а):
> > Of cource, write operations must be grouped becouse memory allocation
> > for write transaction is proportional to database size (see offsite).
>
> This limitation was removed about a year ago around 3.5.7.
Hello!
В сообщении от Monday 16 February 2009 17:42:25 danjenkins написал(а):
> I fully understand that performance will depend on the coding, database
> structure and indexing (& hardware) but, assuming these are taken care of,
> should a 100 million record table perform loosely in the same
Hello!
В сообщении от Monday 16 February 2009 17:18:04 Nathan Biggs написал(а):
> Is that just creating an in-memory database then? I'm not familiar with
> a copy to a null location.
Writes to in-memory database is not saved to disk. If you only want to increase
read speed when
ram-cache of
Hello!
В сообщении от Saturday 14 February 2009 00:33:38 Nathan Biggs написал(а):
> Is there a faster way to read an entire table other then:
>
> select * from table
>
> Not that is is slow, just curious.
On linux you can do
dd if=database.db of=/dev/null bs=1M
and after perform "select ..."
Hello!
В сообщении от Sunday 08 February 2009 20:07:14 Dennis Cote написал(а):
> Alternatively, if you want to use SQL that is more portable, you could
> also cast the result of the SUM function to a floating point value to
> ensure that a floating point division is done.
>
> sqlite> select
Hello!
В сообщении от Thursday 05 February 2009 02:48:25 D. Richard Hipp написал(а):
> The SQLite core will call the locking methods, but they can be no-
> ops. The read method can be a no-op too, I suppose, if you are only
> using the VFS to make a backup. Oh, and the writes will all be
Hello!
В сообщении от Tuesday 03 February 2009 16:22:59 D. Richard Hipp написал(а):
> > How can I detect opened transaction on my database connection from
> > the code? When I start transaction/checkpoint, then I am missing some
> > API or SQL command like 'IsTransactionOpen'.
>
>
Hello!
В сообщении от Monday 02 February 2009 03:31:16 Lukas Haase написал(а):
> I searched a little bit with google but I could not find any code or
> extensions to compress an SQLite database on the fly. Is this possible?
There are functions compress/uncompress in attached file.
Best regards,
Hello!
В сообщении от Tuesday 20 January 2009 12:24:41 vlema...@ausy.org написал(а):
> For now we are just wondering how to use SQlite facilities, and if it's
> not sufficient, maybe we would think of the opportunity to developp a tiny
> compression algorithm by ourselves, or not... There is no
Hello!
В сообщении от Monday 19 January 2009 20:22:33 vlema...@ausy.org написал(а):
> It is a requirement that the size of those copies being as small as
> possible, without having to perform an external compression.
You can using internal data compression. By compressing a few big fields you
Hello!
I did create md5 extension with functions md5() and md5sum() based on
test_md5.c. But "make test"
return errors with this extension. How may it be fixed?
And why did not included md5 functions in SQLite core with SQLITE_MD5 define
(as SQLITE_SOUNDEX for
example)?
Best regards,
Hello!
I'm using in sqlite3IcuInit this code
/* register russian collation as NOCASE */
UErrorCode status = U_ZERO_ERROR;
UCollator *pUCollator;/* ICU library collation object */
pUCollator = ucol_open("ru_RU", );
if( !U_SUCCESS(status) ){
return SQLITE_ERROR;
}
rc =
Hello!
В сообщении от Friday 16 January 2009 18:25:34 jose isaias cabrera написал(а):
> Did not come attached... Will you send it again?
Source:
http://mobigroup.ru/dload/sqlite3.6.7/env.c
Full source:
http://mobigroup.ru/dload/sqlite3.6.7/sqlite-3.6.7.tar.bz2
Compiled:
Hello!
В сообщении от Friday 16 January 2009 00:23:18 Hoover, Jeffrey написал(а):
> Can anyone tell me set-by-step how to add a CURRENT_USER() function to
> SQLLITE that will return the current linux login?
See attached file.
Best regards, Alexey.
___
Hello!
В сообщении от Thursday 15 January 2009 20:07:49 D. Richard Hipp написал(а):
> All this is to say that we believe that SQLite version 3.6.10 is the
> most stable, most thoroughly tested, and bug-free version of SQLite
> that has ever existed. Please do not be freaked out by three
Hello!
В сообщении от Friday 16 January 2009 00:16:43 Thomas Hertweck написал(а):
> It would not make sense to delay bug fixes, but have you ever thought
> about using a different version number scheme? In the Linux kernel
> development
Linux kernel versions compability is bad and so version
Hello!
В сообщении от Thursday 15 January 2009 11:35:10 MikeW написал(а):
> Surely this is a problem with Tcl's ability to sort non-ASCII characters
> rather than SQLite ?
>
> How about using Tcl_UniCharNcasecmp rather than 'string compare' ?
This collation example you can find in official
Hello!
В сообщении от Wednesday 07 January 2009 08:56:02 Craig Smith написал(а):
> CREATE TABLE talks (member_id INTEGER, date DATE, CONSTRAINT
> constraint_ignore_dup UNIQUE (member_id, date) ON CONFLICT IGNORE);
>
> I believe that I understand this statement, except for the term
>
Hello!
В сообщении от Tuesday 06 January 2009 19:29:43 Craig Smith написал(а):
> By searching the archives of this list, I was able to come up with
> this syntax to identify duplicate records and place a single copy of
> each duplicate into another table:
There is simple way: dump your
Hello!
В сообщении от Tuesday 06 January 2009 15:33:42 Sylvain Pointeau написал(а):
> The import has the big limitation to not be able to import the file when a
> field is on multiple lines.I don't know if this is the same for the
> export...
See virtualtext extension from spatialite project.
Hello!
В сообщении от Friday 02 January 2009 18:26:56 Sherief N. Farouk написал(а):
> > Preliminary documentation can be seen at
> > http://www.sqlite.org/draft/lang_savepoint.html
>
> Why savepoints? Why not just add support for named transactions? Is there
> some semantic difference I'm
Hello!
I did find interesting article about this popular question
http://blog.maxindelicato.com/2008/12/how-to-organize-a-database-tables-keys-for-scalability.html
I would also like to add that SQLite supports "attach" command due to which we
are able to use a
lot of database shards on a
Hello!
Imho it's better to create audit table for single table. For example, we can
attach audit
database "audit" and create all tables from main db (without constraints,
triggers and checks).
Before drop or edit record ID in table T execute "insert into audit.T select *
from T where
Hello!
В сообщении от Wednesday 26 November 2008 22:37:19 Brown, Daniel написал(а):
> Is there any functionality built into SQLite to generate CRC values for
> tables? We would like to be able to verify that the contents of the
> table we just updated matches the intended contents. Currently
Hello!
В сообщении от Monday 01 December 2008 18:16:04 D. Richard Hipp написал(а):
> The current TCL interface for SQLite does not provide the ability to
> add aggregate functions written in TCL. So in that sense, it is not
> possible. However, the TCL interface could be extended to add
Hello!
Is it possible?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello!
В сообщении от Wednesday 26 November 2008 13:57:02 Nikhil Kansal написал(а):
> But if I delete a chunk of data then how can I know the id number.
You can get rowid for last inserted row as
select last_insert_rowid();
Best regards, Alexey.
___
Hello!
В сообщении от Sunday 30 November 2008 23:19:52 Igor Tandetnik написал(а):
> Personally, I'd implement logic like this in my application code, rather
> than in ever-more-complex SQL statements.
May be as
create temp table A;
insert into A
select * from table1 where Field2='Red'
Hello!
В сообщении от Saturday 29 November 2008 04:12:06 Richard Kim написал(а):
> Thanks for your link, but it is not really click me too well
> I should set this busy_timeout to longer ms than current ?
Set timeout to 2000, for start.
Best regards, Alexey.
Hello!
В сообщении от Saturday 29 November 2008 01:16:17 Richard Kim написал(а):
> We have database table, and it is being written, sometimes 30 times a
> second.
> Some of the data succeeded, but some aren't.
>
> How should we handle this sort of lock issue ?
Hello!
В сообщении от Monday 24 November 2008 19:16:46 Constantine Vassil написал(а):
> OLAP functionality includes the concept of a sliding *window* that moves
> down
> through the input rows as they are processed. Additional calculations can
> be
>
> performed on the data in the window as it
Hello!
В сообщении от Wednesday 19 November 2008 15:05:01 D. Richard Hipp написал(а):
> That's because "SELECT count(*) FROM t" has to read and count every
> row in the table - all 1.2 million rows. And this involves reading
> all 1.2 million rows from disk. If each row is 100 bytes in
Hello!
Start console SQLite
$ sqlite3
SQLite version 3.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .q
profiling:/usr/src/sqlite3:Cannot create directory
profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip
What is strings
Hello!
В сообщении от Friday 14 November 2008 22:21:45 Shane Harrelson написал(а):
> If you used the supplied configure to generate your makefile, you can
> change the gcov setting in it to:
> USE_GCOV = 0
Thanks!
Best regards, Alexey.
___
Hello!
Start console SQLite
$ sqlite3
SQLite version 3.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .q
profiling:/usr/src/sqlite3:Cannot create directory
profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip
What is strings
Hello!
В сообщении от Wednesday 15 October 2008 16:11:47 D. Richard Hipp написал(а):
> For a summary of changes and enhancements
> that have occurred in version 3.6.4 visit
>
> http://www.sqlite.org/3_6_4.html
Document Not Found
The document /3_6_4.html is not avaivable on this server
Hello!
"Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements."
http://www.sqlite.org/cvstrac/chngview?cn=5772
In test script I can see queries like
"SELECT * FROM t1 NOT INDEXED WHERE b = 10 ORDER BY rowid"
"DELETE FROM t1 INDEXED BY i1 WHERE a = 5 AND b = 10"
But I can't
Hello!
В сообщении от Saturday 04 October 2008 19:36:50 Russell Leighton написал(а):
> For my own purposes I wanted to have '.load' define some meta commands
> as well as custom SQL functions.
>
> Would anyone else find this useful?
I think it's helpful feature. With possibility to redefine
Hello!
Which do "exec xv $name.gif &"? For my debian lenny host there is no xv
utility but with
# if {$do_xv} {
#exec xv $name.gif &
# }
all work fine.
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello!
В сообщении от Friday 03 October 2008 23:10:40 D. Richard Hipp написал(а):
> On Oct 3, 2008, at 1:55 PM, Petite Abeille wrote:
> > Out of curiosity, how did you generate those diagrams?
>
> A Tcl/Tk script generates the diagrams into a canvas widget. The
> script is at:
>
>
Hello!
В сообщении от Thursday 02 October 2008 18:15:01 John Elrick написал(а):
> While I was reading http://sqlite.org/lang_corefunc.html, I noticed what
> appears to be a typo:
>
> 'Return a copy of string /X/ will all ASCII characters converted to
> lower case.'
>
> I believe this is supposed
Hello!
I'm using SQLIte on a few dozens winmobile devices a few years. It's work fine
with standart FS. If you want to try raw access to flash you can find
expiremental VFS code for flash and adopt this code for you. I don't remember
where I did see this code.
Best regards, Alexey.
Hello!
В сообщении от Monday 08 September 2008 17:51:35 Daniel van Ham Colchete
написал(а):
> You might want to take a look at GlusterFS (www.glusterfs.org), it's a
> clustered filesystem that works well with fcntl() (the locking system).
> If you need a smaller latency, it will also work with
Hello!
You can get libSqliteIcu.dll and all needed libraries from
http://dload.mobigroup.ru/sqlite-ext/icu/3.6.2/
Static and shared compiled ICU 3.8 libraries are here
http://dload.mobigroup.ru/icu/3.8/
All binaries compiled by MinGW.
Best regards, Alexey.
Hello!
В сообщении от Wednesday 03 September 2008 18:28:44 Dhiogo Silva написал(а):
> My question is:
> Have you ever done it before? I mean, have you ported ICU to work with
> SQLite?
You must to compile icu lib and after
for linux:
gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so
Hello!
В сообщении от Friday 29 August 2008 02:29:37 D. Richard Hipp написал(а):
> Run this command:
>
> sqlite3 old.db .dump | sqlite3 new.db
This command lost information about page size ans some other.
Best regards, Alexey.
___
sqlite-users
Hello!
В сообщении от Wednesday 27 August 2008 06:52:09 Alexandre Courbot написал(а):
> I know there is a patch at
> http://www.sqlite.org/cvstrac/tktview?tn=3140,38 that is supposed to
> improve Unicode support in FTS3. I suspect it to turn any Unicode
> character into a token - however maybe
Hello!
В сообщении от Tuesday 26 August 2008 21:24:24 Igor Tandetnik написал(а):
> > Thanks, it's better way for my task. But is it safe to logging
> > uncommited changes?
>
> You tell me. Aren't your triggers doing that already?
Well, if I'm writing log to other database in single transaction
Hello!
В сообщении от Tuesday 26 August 2008 18:59:55 Igor Tandetnik написал(а):
> > I don't know method to set triggers on begin and commit transaction
> > events.
>
> You could log begin/end transaction (along with any other statements) by
> installing sqlite3_trace hook.
>
> Another approach
Hello!
В сообщении от Tuesday 26 August 2008 16:44:56 Igor Tandetnik написал(а):
> > Can I group logged queries by any transaction id?
>
> Well, BEGIN TRANSACTION and END TRANSACTION are themselves queries, and
> thus will presumably appear in your log. Any queries in between would
> then belong
Hello!
В сообщении от Tuesday 26 August 2008 15:58:56 Jeffrey Becker написал(а):
> I dont believe sqlite supports named transactions. As such there
> wouldnt be any identifier to get.
Can I group logged queries by any transaction id?
Best regards, Alexey.
Hello!
How can I get transaction identifier or number (my programm lang is tcl)?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello!
В сообщении от Monday 25 August 2008 02:18:56 Susan Ottwell написал(а):
> How would one insert rows randomly within a range of 1000 rows? I can
> easily enough do this in the script that calls the insert function,
> but it would be more efficient if I could use an sqlite function or
Hello!
> On a database of 2.5 million records, it ran over 11 hours before I killed
> it. On smaller datasets it works fine.
> Any Advice?
See explain query plan for indices usage. And query
Select filename, accessCount from
(
SELECT eventTime, Upper(AuditRecords.fileName) fileName,
Hello!
В сообщении от Thursday 21 August 2008 22:45:33 Doug Porter написал(а):
> Our software uses SQLite to save our data and we want to warn a user
> who opens a file that is already opened by another user. I tried a
> homebrewed approach (keep a table of open connections manually), but
> ran
Hello!
В сообщении от Monday 18 August 2008 20:21:04 Thomas Sailer написал(а):
> The following query is very quick, it returns 20 rows within a small
> fraction of a second: select * from mapelements_rtree where NELAT>=7900
> and SWLAT<=8000 and NELON>=7900 and SWLON<=8000;
>
>
Hello!
I did write yesterday message "Table functions emulation" with description of
function for generating table with integers ranging.
create table testrange(rowid);
select intrange2table (1,10,1,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10
В сообщении от Friday 15 August
Hello!
I did write some wrapper for
create table testrange(rowid);
select intrange2table (1,10,1,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10
select intrange2table (100,1000,100,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10
100
It's very dificult decision. I'm prefer to use some callback function
for logging all queries. But I don't know how to realise this callback
- trace and profile callbacks can't show query string with variables
values.
2008/8/11, Dennis Cote <[EMAIL PROTECTED]>:
> Alexey Pechnikov wrote:
Hello!
В сообщении от Wednesday 06 August 2008 17:42:19 Alexandre Courbot написал(а):
> I first noticed that behavior in a much larger query with plenty of
> joins. Reordering them gives me a query that works. Is there any
> reason for this? I don't know sqlite enough to affirm this is a bug,
>
Hello!
I did read prezentation of SQL Anywhere® 11
http://www.sybase.com/files/White_Papers/Sybase_SQLAnywhere_Top10newFeatures_wp.pdf
and there are very useful features which can make replication very simple. How
may be it realised in SQLite?
"1. UNLOAD to a Variable
The LOAD and UNLOAD
Hello!
I think you need to add callback function for insert operations and are
logging in the function.
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello!
See code
http://paste.pocoo.org/show/81137/
Compile as
gcc sqlite_test.c -o sqlite_test -lsqlite3
Create table log in database log.db as
$ sqlite3 log.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table log(value);
sqlite> .q
Start program
./sqlite_test
And
Hello!
В сообщении от Sunday 03 August 2008 17:57:33 David Nelson написал(а):
> must be something i said that was confusing... I've been developing
> in C++ for over 20 years, programming in general for 45 years!
But why you wan't to try C code? Problem may be with MCF CString or your
Hello!
If you can't write C++ code then write C code. I did send C example some time
ago and there are a lot of examples in internet. Try to write and compile C
code and after that you'll can start to learn C++.
Best regards, Alexey.
___
sqlite-users
Hello!
SQLite API has functions for query formatting.
For example:
char *
sqlite3_get_passwd_sqlite(char * file, char* user, char* passwd_type)
{
char *passwd;
char *rec;
sqlite3 *db;
char *sql = NULL;
sqlite3_stmt *stmt;
const char *tail;
int rc;
const char zSql_cleartext[] =
Hello!
В сообщении от Saturday 02 August 2008 16:21:44 gerardo написал(а):
> Hello
> The site for Examples sqlite-latino.blogspot.com
Gracias! But for me "un excelente lenguaje de programación" is tcl :-) Tcl
binding for SQLite is better, I think. And all tests are writed by tcl.
P.S. Did you
Hello!
В сообщении от Saturday 02 August 2008 13:59:54 Graeme написал(а):
> > and in file mksqlite3c.tcl add icu.c in "foreach file" circle before
> > main.c
>
> Thanks Alexey, it worked fine. I would never have thought to change
> mksqlite3c.tcl, so thanks especially for that.
I did create
Hello!
В сообщении от Saturday 02 August 2008 02:40:28 Dwight Ingersoll написал(а):
> SQLite specific. For example, when/why would one choose to attach database
> files over having the scheme reside in one database file, performance
> considerations when databases are attached vs. single file
Hello!
>
> And how about SQLite+ICU compilation? Is it work for you?
>
> In configure.in
I'm sorry, in Makefile.in, of cource.
>
> TCC += -DSQLITE_ENABLE_ICU=1 `icu-config --ldflags`
> LIBOBJ += icu.lo
>
> icu.lo: $(TOP)/ext/icu/icu.c $(HDR)
> $(LTCOMPILE) -c $(TOP)/ext/icu/icu.c
>
Hello!
В сообщении от Friday 01 August 2008 15:49:40 Graeme написал(а):
> On Friday 01 August 2008 16:45:54 Alexey Pechnikov wrote:
> > Hello!
> >
> > В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а):
> > > Try this
> > > http://
Hello!
В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а):
> Try this
> http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll
sqlite3 :memory:
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> SELECT load_extension('libSqliteIcu.dll'
Hello!
В сообщении от Friday 01 August 2008 14:05:09 Christophe Leske написал(а):
> Graeme schrieb:
> > I apparently successfully compiled the ICU extension with:
>
> Has anyone sucessfully compiled the ICU extension for Windows (XP)? If
> so, i would be very interested in the steps, thank you.
>
Hello!
В сообщении от Friday 01 August 2008 11:41:54 Mihai Limbasan написал(а):
> What does
>
> ldd /path/to/your/compiled/libSqliteIcu.so
>
> report?
On linux debian for workable libSqliteIcu.so:
$ ldd libSqliteIcu.so
linux-gate.so.1 => (0xe000)
libm.so.6 =>
Hello!
В сообщении от Friday 01 August 2008 11:10:45 Graeme написал(а):
> > Try to install before
> > libicu-dev
> > libicu38
>
> Thanks Alexey. I have both those installed. I assume you did not change
> anything else to get it to work?
No problem in code. Problem with dependencies.
$
Hello!
В сообщении от Friday 01 August 2008 00:49:56 Graeme написал(а):
> I apparently successfully compiled the ICU extension with:
>
> gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so
>
> but when I try to load it like this (using the TCL API, linux binary from
> the site):
>
> load
Hello!
В сообщении от Thursday 31 July 2008 15:16:55 Christophe Leske написал(а):
> Hi,
>
> i am in need for a like statement which correctly resolves diacritic
> charcaters.
>
> I found this posting on the net:
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg35613.html
>
> So i looked
Hello!
В сообщении от Thursday 31 July 2008 12:10:54 Petr Vanek написал(а):
> > I gave it a try, and it seems as if SQLiteman can´t handle extensions
> > for databases, is this right?
>
> not yet unfortunately. But it's requested already.
>
> http://sqliteman.com/bugtracker/view.php?id=136
>
>
Hello!
В сообщении от Wednesday 30 July 2008 20:21:53 Christophe Leske написал(а):
> Hi Petr,
>
> > I'm glad I can announce new stable version of Sqliteman - the GUI for
> > developers and admins:
> > http://sqliteman.com/
>
> I gave it a try, and it seems as if SQLiteman can´t handle extensions
Hello!
В сообщении от Tuesday 29 July 2008 00:18:40 Scott Hess написал(а):
> On Sat, Jul 26, 2008 at 1:28 PM, Stephen Woodbridge
>
> <[EMAIL PROTECTED]> wrote:
> > Alexey Pechnikov wrote:
> >> I'm know that ispell, myspell, hunspell and trigrams are used in
> >
Hello!
Can I'm using "PRAGMA synchronous" on per-database basis? How to attach
database with "PRAGMA synchronous = OFF;" mode to main database with "PRAGMA
synchronous = ON;" mode?
Best regards, Alexey.
___
sqlite-users mailing list
Hello!
Thanks! I think the workaround can be helpful for me.
There is a few documents about SQLite FTS extension :-(
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello!
В сообщении от Saturday 26 July 2008 21:37:19 Stephen Woodbridge написал(а):
> I have thought a lot about these issues and would appreciate any
> thoughts or ideas on how to implement any of these concepts or others
> for fuzzy searching and matching.
I'm know that ispell, myspell,
Hello!
And how about stemming? Can I'm using ispell, myspell, hunspell? And trigrams?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
В сообщении от Saturday 26 July 2008 10:23:57 Roger Binns написал(а):
> Alexey Pechnikov wrote:
> >> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're
> >> looking for here.
>
> Unfortunately sqlite3_trace isn't that useful as it only tells you the
Hello!
В сообщении от Wednesday 23 July 2008 19:07:59 вы написали:
> Hello,
>
> Le 23 juil. 08 à 09:14, Alexey Pechnikov a écrit :
> > Hello!
> >
> > Send me please code as attached file.
> > In mail body there are a lot of non-ascii symbols and compiler show
&
В сообщении от Friday 25 July 2008 22:11:42 Harold Wood написал(а):
> yes there is.
>
> embed the sql in a table then execute it as needed passing the appropriate
> parms.
How can I create this function?
Example:
select generate_series(1,7);
1
2
3
4
5
6
7
Hello!
There is any way to create 'table functions', which are functions that return
a rowset and are used in place of a table to generate rows?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
В сообщении от Friday 25 July 2008 16:32:26 Derrell Lipman написал(а):
> > Can I get full log of sql statements for to sent it other network or
> > store to
> > outher device?
>
> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're
> looking for here.
Thanks!
В сообщении от Friday 25 July 2008 12:16:39 Roger Binns написал(а):
> Alexey Pechnikov wrote:
> > May be on FS layer?
>
> I specifically said VFS which is SQLite functionality - see
> http://www.sqlite.org/c3ref/vfs.html and
> http://www.sqlite.org/c3ref/io_methods.html
В сообщении от Thursday 24 July 2008 22:00:45 Brown, Daniel написал(а):
> Morning List,
>
> Another morning another question, what sort of facilities does SQLite
> provide for Loading from a read only storage location and then saving
> changes to a separate read/write storage unit? I know I can
401 - 500 of 553 matches
Mail list logo
