В сообщении от Friday 25 July 2008 03:40:22 Roger Binns написал(а):
> Alexey Pechnikov wrote:
> > Is any way to repair corrupted database?
>
> From a theoretical point of view the only way to repair a corrupted
> database is if there are multiple redundant copies of data
В сообщении от Thursday 24 July 2008 20:48:08 Alexey Pechnikov написал(а):
> Hello!
>
> Is any way to repair corrupted database? May be I have archive copy of
> database and corrupted this pages - can I get correct pages and merge their
> with archive database?
>
> P.S
Hello!
Is any way to repair corrupted database? May be I have archive copy of
database and corrupted this pages - can I get correct pages and merge their
with archive database?
P.S. I have no corrupted database now but this question is important for me.
Best regards, Alexey.
В сообщении от Wednesday 23 July 2008 15:42:04 Igor Tandetnik написал(а):
> "Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in
> message news:[EMAIL PROTECTED]
>
> > select * from direction_telephony
> > where prefix in
> > ('78312604812','7831260481','7
Hello!
How can I emulate PostreSQL function select generate_series?
==
Example:
select generate_series(1,7);
1
2
3
4
5
6
7
==
My task is this:
create table direction_telephony (
group_name text not null,
name text not null,
class text not null,
prefix text not null,
Hello!
Can I found functions for ip address/mask operations?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
В сообщении от Monday 21 July 2008 04:59:10 Kang Kai написал(а):
> Thanks for sharing your experience, would you please introduce how you deal
> with the concurrency?
I'm using AOL web server + tclsqlite. Small and fast read/write transactions +
in-memory && file-based database replicas + "db
В сообщении от Sunday 20 July 2008 23:39:34 Alexey Pechnikov написал(а):
> > The good news is that you can re-implement the LIKE function fairly
> > easily. There have been a number of posts in the past dealing with
> > using external Unicode/I18N libraries to impleme
В сообщении от Sunday 20 July 2008 21:20:19 Jay A. Kreibich написал(а):
> The good news is that you can re-implement the LIKE function fairly
> easily. There have been a number of posts in the past dealing with
> using external Unicode/I18N libraries to implement a more complete
> 'LIKE'
Hello!
I did migrate two projects from PostgreSQL (one is ~22 Gb database with very
complex reports) and now migrate oracle project (>100 Gb billing database
with distributed data collectors) for best performance on multi-core servers
and SATA disks. SQLite database may be replicated or copied
В сообщении от Friday 18 July 2008 18:34:01 Fabio Ceconello написал(а):
> Hello,
>
> I just needed to write this little utility to load a regular file to a
> BLOB in a SQLite database, and I thought it may be useful to someone
> else, so I'm posting it here.
I think, you may add this to page
Hello!
I try this code
create trigger view_objects_update before update on view_objects begin
select RAISE (ABORT,'Row id=' || NEW.id);
end;
but get "SQL error: near "||": syntax error". How can I do it?
Best regards, Alexey.
___
sqlite-users
В сообщении от Thursday 10 July 2008 20:15:06 Lauri Ojansivu написал(а):
> If you mean making extensions with C, look at the wiki.tcl.tk :
> http://wiki.tcl.tk/_search?_charset_=UTF-8=extension
>
> If you mean additional commands or fuctions for SQLite with Tcl, look
> at TkSQLite:
>
Hello!
How can I make tcl lodable extensions? It's possibly on pythone and how about
other languages?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
В сообщении от Monday 07 July 2008 16:38:56 Raphaël KINDT написал(а):
> I use Blob because I don't know how many bits I must use (maybe 1024 bits
> or more). It's the user choice not mine. Moreover, I think Blob takes less
> space than Bool field (which is TINYINT or somethings like that).
And
В сообщении от Monday 07 July 2008 13:42:11 Raphaël KINDT написал(а):
> Hello,
>
> I use an events table which looks like this:
>
> CREATE TABLE events(
>time REAL NOT NULL,
>detections BLOB);
>
> I want to select all events which have the BIT3 of detections field enable
>
В сообщении от Wednesday 02 July 2008 22:42:48 Alex Katebi написал(а):
> Do you mean the sqlite3_busy_timeout( ) ?
> I never thought I could use it for simulating this.
> I will give that a shot.
Client don't get database busy error but sleep some time and execute query
later.
В сообщении от Wednesday 02 July 2008 08:25:10 Dan написал(а):
> > I'm using SQLite 3.5.9 and there are no differents in my tests
> > between DESC
> > and default indeces. I try create index with keywork DESC for
> > optimize DESC
> > sorting but it don't work for me. My tests you can see
В сообщении от Tuesday 01 July 2008 23:47:50 [EMAIL PROTECTED] написал(а):
> On Tue, 1 Jul 2008, Alexey Pechnikov wrote:
> > Is any difference between "CREATE INDEX ev_idx ON events(type,eid)"
> > and "CREATE INDEX ev_idx ON events(type,eid desc)"? W
Is any difference between "CREATE INDEX ev_idx ON events(type,eid)"
and "CREATE INDEX ev_idx ON events(type,eid desc)"? What is "desc" keyword
for index?
___
sqlite-users mailing list
sqlite-users@sqlite.org
В сообщении от Tuesday 01 July 2008 19:26:47 John Stanton написал(а):
> I haven't looked closely at this problem but a cursory glance suggests
> that Sqlite is not using an ASC indesx if there is a DESC ORDER By clause.
But primary key index work fine. Why?
> Try doing the selection ASC and then
Really, there is problem with multi-column indexes. You must use only primary
key index for ">=" where clause and "ASC" sorting and "<=" where clause and
DESC sorting.
1. I try with primary key:
#!/usr/bin/tclsh
package require sqlite3
sqlite3 db index_order.db
db eval {DROP TABLE IF EXISTS
I try with this script on my laptop with 1 Gb RAM
#!/usr/bin/tclsh
package require sqlite3
sqlite3 db index_order.db
db eval {DROP TABLE IF EXISTS events}
db eval {CREATE TABLE events (eid INTEGER PRIMARY KEY)}
db eval {CREATE INDEX ev_desc_idx ON events(eid desc)}
db transaction {
for
Show results of this queries:
select max(eid) from events;
select count(eid) from events;
select count(eid) from events where type=22;
select count(eid) from events where eid<=3261976;
select count(eid) from events where eid<=3261976 and type=22;
___
ce I don't know if that would
> distort the results) - literally, a wall clock. But it is noticeably
> a little slower. Any ideas?
> Thanks,
> Jeff
>
> On Jun 28, 2008, at 4:29 AM, Alexey Pechnikov wrote:
> > В сообщении от Saturday 28 June 2008 02:28:05 Jeff Gibson
>
В сообщении от Saturday 28 June 2008 01:20:49 John Stanton написал(а):
> I have seen such indices. The key is evaluated at the time the record
> is inserted and an index built. The poster could use a trigger with an
> update to place the evaluated expression into a colum.
Excellent! It's
В сообщении от Saturday 28 June 2008 02:28:05 Jeff Gibson написал(а):
> When I do the following query:
>
> SELECT events.* FROM events WHERE ( events.type=22) AND ( events.tid=9)
> AND (events.eid<=3261976) AND (events.verbose<=1) ORDER BY events.eid
> DESC LIMIT 1;
>
> it's very slow. If I
В сообщении от Saturday 28 June 2008 02:28:05 Jeff Gibson написал(а):
> I have a large table and a two column index:
How much rows are you have?
___
sqlite-users mailing list
sqlite-users@sqlite.org
В сообщении от Friday 20 June 2008 03:00:21 Stephen Woodbridge написал(а):
> This looks interesting:
> http://sqlitedbms.sourceforge.net/index.htm
>
> Alexey would this work for your multi-master replication? Maybe you
> modify this to work for the specific task you have in mind.
May be I can
В сообщении от Thursday 19 June 2008 17:40:14 Dennis Cote написал(а):
> Stephen Woodbridge wrote:
> > Well if the index requires fewer page reads then it should be
> > proportionally faster. For example if you can only get 5 rows on a page
> > but 25 index entries, you have 1/5 the number of pages
> I use mutexes set up as read or write locks around Sqlite to synchronize
> access.
In Sqlite 3.5.9 function "db timeout" work fine, I was test it. So internal
mutex is enough now, I think.
___
sqlite-users mailing list
sqlite-users@sqlite.org
В сообщении от Thursday 19 June 2008 21:47:12 Stephen Woodbridge написал(а):
> Alexey Pechnikov wrote:
> > В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge
написал(а):
> >> Alexey Pechnikov wrote:
> >>> Hello!
> >>>
> >>>
В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge написал(а):
> Alexey Pechnikov wrote:
> > Hello!
> >
> > Is any method for multy-master replication of SQLite databases?
>
> http://www.google.com/search?num=100=en=1=sqlite++replication
Are you really sa
Hello!
Is any method for multy-master replication of SQLite databases?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
В сообщении от Thursday 19 June 2008 02:37:57 Dennis Cote написал(а):
> I'm not sure if you even need unique id numbers for these records, or
> why you are concerned that there might be multiple records with the same
> save_date for that matter? Is this table linked to any others?
I'm using URL
В сообщении от Thursday 19 June 2008 01:09:42 Teg написал(а):
> I doubt the COUNT in Sqlite could be any faster. You really notice the
> slowdown though, the first time you access the DB and nothing's in
> cache.
I think, you can use index directly as
create index id_idx on mytable(id);
select
В сообщении от Thursday 19 June 2008 00:22:37 Dennis Cote написал(а):
> Alexey Pechnikov wrote:
> > I'm replicating my database using sqlite dump and load or sql queries.
> > I'm not sure that rowid is not different after that.
>
> If you assign each row an id (and even bett
В сообщении от Wednesday 18 June 2008 23:40:05 John Stanton написал(а):
> Alexey Pechnikov wrote:
> > В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а):
> >> The magic potion is the ability to embed Sqlite in the application
> >> server and avoid
В сообщении от Wednesday 18 June 2008 22:44:16 Dennis Cote написал(а):
> Alexey Pechnikov wrote:
> > I find get only _one_ row. I found correspond timestamp by other
> > questions. I don't want get more than one row.
>
> In that case you would be better off to get the ro
В сообщении от Wednesday 18 June 2008 21:32:46 Dennis Cote написал(а):
> Alexey Pechnikov wrote:
> > There is problem for select one row by time - we must use query
> > select * from events where time || =julianday('2008-06-16 23:59:59.999');
> > and index is not used for
В сообщении от Tuesday 17 June 2008 20:59:19 Dennis Cote написал(а):
> I would recommend that you change your database schema an combine your
> timestamp string and subsecond integer field into a single floating
> point julian day number that provides both pieces of information in
> units of days
В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а):
> The magic potion is the ability to embed Sqlite in the application
> server and avoid IPCs and multiple processes.
Why not multiple processes? And what about threads? If Sqlite library is used
in multi-threaded
В сообщении от Monday 02 June 2008 19:40:58 Alex Katebi написал(а):
> Hi All,
>
> I am using remote procedure calls (RPC) for SQLite in my application. I
> have implemented a few SQLite RPC functions that I needed successfully.
> I am wondering if there are other people like me who need this.
>
В сообщении от Friday 13 June 2008 20:38:42 Andrew Brampton написал(а):
> Hi Donald,
>
> I have a index on both lat and long, but please correct me if I'm wrong,
> but I think SQLite will only use a single index per SELECT. So only one of
> the index is in use. I think the EXPLAIN command confirms
Hello!
I try:
$ gcc -shared -lm icu.c `icu-config --ldflags` -o libSqliteIcu.so
[EMAIL PROTECTED]:~/sqlite/ext/icu$ sqlite3 :memory: "SELECT
load_extension('/usr/lib/sqlite3/libSqliteIcu.so');"
SQL error: error during initialization:
$ gcc -shared fts3.c -o libSqlitefts3.so
[EMAIL
В сообщении от Friday 13 June 2008 16:26:01 Igor Tandetnik написал(а):
> "Taylor Basilio" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]
>
> > On Jun 13, 2008, at 7:41 PM, Igor Tandetnik wrote:
> >> "Taylor Basilio" <[EMAIL PROTECTED]>
> >> wrote in message
> >> news:[EMAIL
Hello!
How can I create table sqlite_extensions? I read
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
and try
sqlite> create table sqlite_extensions (
...> load INT, -- the order in which the extension
...>-- is to be loaded/initialized.
...>
> The extension-functions file doesn't actually implement any of the
> math functinos, it simply acts as a glue layer between SQLite and the
> system math library. In this case, it looks like the run-time linker
> that loads the extension can't resolve the call for log() from the
>
> Note: You cannot use these functions from the sqlite3 program, you
> must write your own program using the sqlite3 API, and call
> sqlite3_enable_load_extension. See "Security Considerations" in
> http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions.
I can load other extensions and use
В сообщении от Friday 06 June 2008 03:51:38 P Kishor написал(а):
> http://sqlite.org/contrib/download/extension-functions.c?get=22
$ wget http://sqlite.org/contrib/download/extension-functions.c?get=22
$ mv extension-functions.c?get=22 extension-functions.c
$ gcc -fPIC -shared
В сообщении от Monday 09 June 2008 17:52:24 Dennis Cote написал(а):
> If you
> consider dates to be equal when the two dates are the same to within one
> second, then you could use that value as your maximum difference. Since
> a julian day number has units of days, you can use a value of 1/86400
> Please read the recent thread "What is quicker" which has a long
> discussion on the limitations of floating point.
>
> A short summary might be, "Unless you assume that any value stored in
> floating point format is only an approximation to the input value, you
> will run into trouble sooner or
1. I try to select:
sqlite> select save_date from photo_tags where save_date<2454612.21079943
limit 1 offset 3073;
save_date = 2454612.21079943
But 2454612.21079943<2454612.21079943 is wrong result.
2. And I try
sqlite> select save_date from photo_tags where save_date=2454612.21079943;
501 - 553 of 553 matches
Mail list logo