On Wed, May 22, 2019 at 03:43:13PM -0400, Richard Hipp wrote:
> On 5/22/19, Sebastian Kemper wrote:
> >
> > Hello Richard,
> >
> > I have run-tested this with qemu on two targets until now:
> >
> > arm_arm1176jzf-s_vfp
> > armeb_xscale
> >
>
On Mon, May 20, 2019 at 09:10:20PM +0200, Sebastian Kemper wrote:
> On Mon, May 20, 2019 at 02:46:47PM -0400, Richard Hipp wrote:
> > On 5/20/19, Sebastian Kemper wrote:
> > > In OpenWrt's forum a user raised a topic about being unable to use
> > > Ast
On Mon, May 20, 2019 at 02:46:47PM -0400, Richard Hipp wrote:
> On 5/20/19, Sebastian Kemper wrote:
> > In OpenWrt's forum a user raised a topic about being unable to use
> > Asterisk on his armeb xscale device.
>
> Please download a tarball of the latest trunk version o
Hello list,
In OpenWrt's forum a user raised a topic about being unable to use
Asterisk on his armeb xscale device. We narrowed it down to sqlite.
Asterisk was unable to insert a simple table.
Couldn't prepare statement 'CREATE TABLE IF NOT EXISTS astdb(key
VARCHAR(256), value VARCHAR(256), PR
), the full query includes additional
things like selecting properties of certain ancestors along the path.
Best,
Sebastian
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite
3.26.0 it takes over 6 seconds (with the full data set of around 24000
items, it seems to become infeasible).
Thanks and best,
Sebastian Bank
CREATE TABLE languoid (
id VARCHAR(8) NOT NULL,
parent_id VARCHAR(8),
PRIMARY KEY (id),
FOREIGN KEY(parent_id) REFERENCES languoid (id)
);
INSERT
an UI which connected to an older SQLite. Case closed.
Regards,
Sebastian
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Oct 25, 2018, at 16:20, Richard Hipp wrote:
> Sebastian: Presumably this problem arose for you in a much larger and
> more complex application. Can you please apply the patch from the
> check-in above (or recompile using the latest trunk version of SQLite)
> and verify for
S (2, 1, 2);
INSERT INTO account VALUES (2, '');
-- returns [1, 2], expecting 1
SELECT user.id FROM user INNER JOIN account ON user.account = account.id WHERE
user.active = 1 AND user.active = 1;
This only affects the in-memory db, file based is working correctly. Do I miss
something
suspected?
Or both?
Or something else?
No big problem, I can work with sqlite3_column_name. It would just have been
more convenient to have the reverse function, too.
Sebastian
On Mon, 3 Sep 2018 07:27:23 +
Hick Gunter wrote:
> The name of an output column is not even defined, muc
mention that in the documentation?)
Sebastian
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ed by sqlite3_column_database_name.
Or at least use the same terms in both pages?
The names returned are the original un-aliased symbolic name of the database,
...
Sebastian
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.or
I need to know if there are some order of penalty in attach (2+) databases to
make a small (3 tables) join... (one table per DB). vs. (3 tables on
same DB).
I need it to get a small order concurrency writes...
I have 3 process writting to one to each DB. but i need query everithing
w
esellschaft: 86167 Augsburg
Registergericht: Amtsgericht Augsburg HRB 31802-Ursprüngliche Nachricht-
Von: drhsql...@gmail.com Im Auftrag von Richard Hipp
Gesendet: Dienstag, 10. April 2018 12:29
An: SQLite mailing list
Cc: Priebe, Sebastian
Betreff: Re: [sqlite] Build error in SQL
Hello,
this error still exists.
Please fix it.
Greetings
Sebastian
SII Technologies GmbH
Geschäftsführer: Robert Bauer
Sitz der Gesellschaft: 86167 Augsburg
Registergericht: Amtsgericht Augsburg HRB 31802-Ursprüngliche Nachricht-
Von: Priebe, Sebastian
Gesendet: Montag, 24. April
ace it is used there is no
such restiction.
Greetings
Sebastian
--
+++ CADCON ist Mitglied der SII Group +++
Mehr auf unserer neuen Homepage > www.cadcon.de
--
recently there was this on the mailing list:
> Date: Thu, 18 Sep 2014 10:38:38 +0200
> From: RSmith
>
> On 2014/09/18 08:18, Keith Medcalf wrote:
> > ...long article...
>
> Thanks Keith for taking the time, I imagine this is a topic you are
> passionate about and I think it should be publish
As a side note: I've compiled some performance data and published them as
an article on my blog:
http://manski.net/2012/10/01/sqlite-performance/
Do these result seem to be ok?
- Sebastian
On Mon, Sep 24, 2012 at 5:02 PM, Olaf Schmidt wrote:
> Am 24.09.2012 11:26, schrieb S
Ok, then: is this the expected behavior?
On Fri, Sep 28, 2012 at 3:29 PM, Richard Hipp wrote:
> On Fri, Sep 28, 2012 at 9:23 AM, Sebastian Krysmanski
> wrote:
>
> > Yes, I know that. It's just that the error code reported by
> > "sqlite3_step()" is inconsis
Yes, I know that. It's just that the error code reported by
"sqlite3_step()" is inconsistent.
On Fri, Sep 28, 2012 at 3:21 PM, Richard Hipp wrote:
> On Fri, Sep 28, 2012 at 9:09 AM, Sebastian Krysmanski
> wrote:
>
> > Hi,
> >
> > I'm working on
ndows "sqlite3_step()" returns "SQLITE_READONLY" in both
directions but on Linux (or on Android, to be more precise) I get
"SQLITE_READONLY" when changing from DELETE to WAL but I get "SQLITE_IOERR"
("disk I/O error") when changing from
REDCACHE]) is stored
in memory only (i.e. not on the disk), right? What's its size in memory?
Or, on what factors does this size depend on?
Thanks
Sebastian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/sec)
Testing with multiple connections (ReadWrite) and filled table...
Elapsed: 13.6 s (146,847.6 stmt/sec)
- Sebastian
On Mon, Sep 24, 2012 at 11:26 AM, Sebastian Krysmanski wrote:
> Ok, I tried that. It definitely improves performance when using a lot
> threads (15+) but decreas
THREAD_COUNT: 100
Testing with one connection (ReadWrite) and filled table...
Elapsed: 11.8 s (169,204.7 stmt/sec)
Testing with multiple connections (ReadWrite) and filled table...
Elapsed: 15.0 s (133,612.1 stmt/sec)
- Sebastian
On Fri, Sep 21, 2012 at 7:45 PM, Keith Medcalf wrote:
>
> On Frid
of "sqlite3_enable_shared_cache" (
http://www.sqlite.org/c3ref/enable_shared_cache.html) it should be
mentioned whether this function is thread-safe or not.
Best regards
Sebastian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
0 s
Testing with multiple connections (ReadWrite) and filled table...
Elapsed: 54.2 s
- Sebastian
On Fri, Sep 21, 2012 at 6:03 PM, Olaf Schmidt wrote:
> Am 20.09.2012 17:40, schrieb Sebastian Krysmanski:
>
>
> >> What's your threading mode?
> >> http://www.sqlite.or
Well, I thought that WAL and the old locking mechanisms allowed for concurrent
read access. (That's why I thought this would be true for a shared connection
as well - which apparently isn't true.)
On Thursday, 20. September 2012 at 15:55, Keith Medcalf wrote:
> > Two separate database connecti
Ok - could you elaborate on the first "this is what one would expect". What
difference does it make whether I use two threads or 20 threads with one
connection when all operations are serialized? Shouldn't both cases have the
same throughput?
On Friday, 21. September 2012 at 03:52, Keith Medca
g
> (mailto:sqlite-users-boun...@sqlite.org)] on behalf of Sebastian Krysmanski
> [sql...@lists.manski.net (mailto:sql...@lists.manski.net)]
> Sent: Thursday, September 20, 2012 10:25 AM
> To: sqlite-users@sqlite.org (mailto:sqlite-users@sqlite.org)
> Subject: EXT :Re: [sqlite] Store e
ating Unit
> Northrop Grumman Information Systems
>
>
> From: sqlite-users-boun...@sqlite.org
> (mailto:sqlite-users-boun...@sqlite.org) [sqlite-users-boun...@sqlite.org
> (mailto:sqlite-users-boun...@sqlite.org)] on behalf of Sebastian Kry
1.6 s
--
SELECT_COUNT: 20,000
THREAD_COUNT: 100
Testing with one connections (ReadWrite) and filled table...
Elapsed: 11.5 s
Testing with one connections (ReadWrite) and filled table...
Elapsed: 55.9 s
On Thursday, 20. September 2012 at 16:22, Teg wrote:
> Hello Sebastian,
>
> Is this tota
Well, I thought that WAL and the old locking mechanisms allowed for concurrent
read access. (That's why I thought this would be true for a shared connection
as well - which apparently isn't true.)
On Thursday, 20. September 2012 at 15:55, Keith Medcalf wrote:
> > Two separate database connecti
read, both
cores are used.
* Each thread gets its own compiled/prepared statement.
I've posted the test code here:
http://pastebin.com/RHXWfrdx
Again, it's C# but should be understandable anyway.
- Sebastian
On Thursday, 20. September 2012 at 15:52, Black, Michael (IS) wrote:
>
OINT Solutions Operating Unit
> Northrop Grumman Information Systems
>
>
> >
> > >
> > >
> > >
> > > On Thursday, 20. September 2012 at 15:23, Richard Hipp wrote:
> > >
> > > > On Thu, Sep 20, 2012 at 9:12 AM, Sebastian K
Ah - I didn't know that. Thanks for the clarification.
On Thursday, 20. September 2012 at 15:28, Richard Hipp wrote:
> On Thu, Sep 20, 2012 at 9:25 AM, Sebastian Krysmanski <
> sql...@lists.manski.net (mailto:sql...@lists.manski.net)> wrote:
>
> > So you mean, that ev
So you mean, that even read operations (SELECT) are not concurrent?
On Thursday, 20. September 2012 at 15:23, Richard Hipp wrote:
> On Thu, Sep 20, 2012 at 9:12 AM, Sebastian Krysmanski <
> sql...@lists.manski.net (mailto:sql...@lists.manski.net)> wrote:
>
> > Hi,
>
g the error message
in thread local memory? (I'm a C# and Java developer, so I'm not sure whether
thread local memory even exists in C. It does in C# and Java though.)
Best regards
Sebastian
___
sqlite-users mailing list
sqlite-users@sqlite.or
I know 3 desktop app... wich make an PHP tunnel to manage sqlite3 db...
1) Navigat SQL Free (has version for free)
2) SQL Maestro for sqlite (has version for free i think..)
3) Ems Manager for sqlite
--- On Fri, 7/20/12, Kieran Hever wrote:
> From: Kieran Hever
> Subject: [sqlite] sqllit
i'm working on a small ecommerce site for latin america..
http://comercialibre.com
this website is using sqlite3 for store website pages as cache
there are some burst of 60 concurrent users and sqlite is working great for
this app layout..
__
you can do:
update t1 set (a,b)=(select a, b from t2 where t1.id=t2.id)
just like oracle do
--- On Thu, 3/8/12, Marc L. Allen wrote:
> From: Marc L. Allen
> Subject: [sqlite] How efficient is this?
> To: "sqlite-users@sqlite.org"
> Date: Thursday, March 8, 2012, 12:53 PM
> I'm trying
ng without recompile sqlite ? (i have
sqlite with php on shared hosting).
att.
sebastian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
es out
there?
Regards,
Sebastian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
] my new site is using as backend sqlite
On 14-07-2011 21:40, Sebastian Bermudez wrote:
> i have this new micro site ready for my personal office
>
> http://urlit.tk
>
>
> this site is using sqlite as backend
>
> please, don't smile !! this is very very m
i have this new micro site ready for my personal office
http://urlit.tk
this site is using sqlite as backend
please, don't smile !! this is very very micro site. for my personal url
shorter function
___
sqlite-users mailing list
sqlite
simple question:
i have table tsamov
create table tsamov (
tsamov_id integer not null primary key
,tsamov_descri text,
,tsamov_code text )
i have index on tsamov_code (it's varchar column of lenght=5)
could the next query use the tsamov_code index ??:
select * from tsamov where tsamov_c
I'm using sqlite v3 as database backend for an very small web app (some of 20
concurrent users -really serial access users-).. in Ms. Win xp (my test/develop
env.) it work perfectly...my web app can handle that load(and even more by
My JMeter Tests)...
But on my production environment (L
I'm using sqlite v3 as database backend for an very small web app (some of 20
concurrent users -really serial access users-).. in Ms. Win xp (my test/develop
env.) it work perfectly...my web app can handle that load(and even more by
My JMeter Tests)...
But on my production environment (L
try :
$strQuery ="SELECT CASE WHEN
substr(substr(eTimeStart,1,2),-1) =\':\' THEN
substr(eTimeStart,1,1)||substr(etimeStart,3,2) ELSE
substr(eTimeStart,1,2)||substr(eTimeStart,4,2) END as aTIME
FROM EVENTS
WHERE Cast(eMonth as int)= 2 AND CAST(eYear as
INT)=2010 and CAST(eDay as
INT)=13 OR
each SELECT-FOR-UPDATE query when uploading the
scripts..and undo when donwload the site
Can You support the FOR UPDATE construction in a dummy mode ???
Att.
Sebastian Bermudez
PD: sorry i don't study english
Yahoo! Cocina
Encontra las mejores recetas con Yahoo! Cocina.
http:
i have an very small web site ( 60/80 Concurrent users )... running with
mysql.. but i need transactions ( and my web hosting does not support
innodb )
but have support for SQLITE 2.x & 3.x)...
The web site has built with PHP using PDO.. the max..db-load for a
requestis.
look this:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
is for mysql but aplies to every sql DB
- Mensaje original
De: Michael Chen
Para: sqlite-users@sqlite.org
Enviado: mié, octubre 14, 2009 10:40:45 AM
Asunto: [sqlite] how to represent a tree in SQL
Dear t
you can attach a new slqite DB..
do insert into new_table_in_new_db select * from mem_table;
deatach db
- Mensaje original
De: Andres Velasco Garcia
Para: sqlite-users@sqlite.org
Enviado: miércoles 30 de septiembre de 2009, 12:27:24
Asunto: [sqlite] In-memory database backup
Hel
i can't call sqlite3_column_type before sqlite3_step !!
from sqlite.org:
"...If the SQL statement does not currently point to a valid row, or if the
column index is out of range, the result is undefined. These routines may only
be called when the most recent call to sqlite3_step() has returned S
i have 1 table:
create table t1 ( id integer not null primary key, descri text )
then i exec... "SELECT * FROM t1"
when i get the column type... with [ sqlite3_column_type(stmt,index); ]
i get always (int)5 = SQLITE_NULL
every else is correct !, i have the correct row count, field count; value
No ! use mysql
that Concurrency on sqlite have high depend... from HW. (sqlite handles
transaction one at time !)... 100 Concurrent Tx. (5 sec. each one)...the last
pooled user must to wait 500 sec... to complete
--- El mar 22-sep-09, CityDev escribió:
> De: CityDev
> Asunto: [s
Objects maps to tables...
fields maps to objects properties..
if you want just store all objects and read all objects
create an entitites tables like:
create table entity ( object as text )
and serialize that objects to database.
--- El jue 10-sep-09, Shaun Seckman (Firaxis)
escribió:
>
ok. i'm develop... an PHP-WEB Sqlite TUNNEL that PHP get a request, process
it and send results to client (desktop app)
In the client side, i have my Own Ado Like Data Access components
my Question is:
my cliente send a query "select * from tableA"
the PHP exec the query and return an
i made it encoding image with base64...
--- El lun 7-sep-09, Eka Rudito escribió:
> De: Eka Rudito
> Asunto: [sqlite] how to save image to sqlite..
> Para: sqlite-users@sqlite.org
> Fecha: lunes, 7 de septiembre de 2009, 8:35 pm
> hello there
>
> i am new bie in sqlite and this forum too..
>
1)
Ok, change the index to:
CREATE INDEX IF NOT EXISTS log_idx ON log (timestamp)
column Id is not used for select...
the Id column just is needed for delete operation.
2) what's log period your app.have ?
Need Year ? Month ? Day ?
can you change the REAL data type for an smaller one ? (integ
table groups ( group_id, group_descri )
table access ( rela_group, rela_code)
--- El jue 3-sep-09, karenebs escribió:
> De: karenebs
> Asunto: [sqlite] Defining user groups in SQLite table
> Para: sqlite-users@sqlite.org
> Fecha: jueves, 3 de septiembre de 2009, 2:57 pm
>
> I have a databa
__
> From: sqlite-users-boun...@sqlite.org
> [sqlite-users-boun...@sqlite.org]
> On Behalf Of Simon Davies [simon.james.dav...@googlemail.com]
> Sent: Wednesday, September 02, 2009 9:05 AM
> To: General Discussion of SQLite Database
> Subject: Re
> Fecha: miércoles, 2 de septiembre de 2009, 9:12 am
> 2009/9/2 Sebastian Bermudez :
> > hi! i have an table ( articles ) with a column for
> EAN13 Barcodes like (
> > 7790080066784).
> > I have created the column with Integer data type... (
> i have chose that da
or 8 bytes depending on the magnitude of the
value.") but when i insert this value for that column... i get 0 (cero) stored
in that place...
Have any idea ?
Att.
Sebastian
PD: Sorry i don't study english
Yahoo! Cocina
Encontra las mejores recetas con Yahoo! Cocina.
http://ar.mu
Hi Simon and Roger,
Simon Slavin wrote:
> On 15 Aug 2009, at 9:58am, Sebastian Arcus wrote:
>
>
>> I've just noticed another interesting thing. A read operation after a
>> write on same table (like a SELECT statement after an INSERT) works
>> perfectly fine - i
Roger Binns wrote:
>
> Sebastian Arcus wrote:
>
>> Hi and thanks for the suggestion. I did as you advised and ran 'vmstat
>> 1' in a terminal. Very little activity - maybe 20-40kb every 6-7 seconds
>> on the bo - pretty much nothing on bi. Also, zeros a
Roger Binns wrote:
>
> Sebastian Arcus wrote:
>
>> Hi and thanks for the suggestion. I did as you advised and ran 'vmstat
>> 1' in a terminal. Very little activity - maybe 20-40kb every 6-7 seconds
>> on the bo - pretty much nothing on bi. Also, zeros a
Roger Binns wrote:
> Sebastian Arcus wrote:
>
>> The SQLite documentation talks about entire database locks by operations
>> of the order of milliseconds - 10 seconds seems a long way off.
>>
>
> There is a possible but unlikely cause for what you are see
able are fast.
The setup is:
OS: Slackware Linux 12.2
Kernel: 2.6.27.7
CPU: Intel Core 2 Duo ULV 2500 (1.2GHz)
RAM: 2GB
XULRunner: 1.9.0.7
SQLite: 3.6.6.2
Many thanks for any suggestions or ideas.
Sebastian
___
sqlite-users mailing list
sqlite-users
I see that sqlite is great for development but for production would
that be a bright idea?
see ya
sebey
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Begin forwarded message:
> From: sebastian stephenson <[EMAIL PROTECTED]>
> Date: 8 May 2008 12:37:54 IST
> To: sqlite-users@sqlite.org
>
> what do I need to do to build sqlite?
>
> see ya
>
> sebey
>
>
see ya
sebey
__
what do I need to do to build sqlite?
see ya
sebey
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Quoth "Igor Tandetnik" <[EMAIL PROTECTED]>:
> Sebastian Tennant <[EMAIL PROTECTED]>
> wrote:
>> I have three tables; users, propositions, and subscriptions:
>>
>> users
>> -
>> user_id user_name user_password user_email
>>
e he didn't propose them).
B: SELECT prop_id FROM subscriptions WHERE (user_id = U03 )
prop_id
P02 He can't subscribe to this one
(becuase he is already subscribed to it.)
Any help very much appreciated.
Sebastian
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
much appreciated.
Sebastian
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
y key (doesn't make sense
since its already there, does it?).
Hav you got any explanations? Is this an expected behaviour or is it just a
bug?
The workaround is, of course, not to declare columns as INTEGER PRIMARY KEY
if you want do ORDER BY them.
Sebastian Setzer
75 matches
Mail list logo
