2016-04-20 22:40 GMT+02:00 Cecil Westerhof :
> 2016-04-20 22:35 GMT+02:00 Cecil Westerhof :
>
>> 2016-04-20 22:21 GMT+02:00 Scott Robison :
>>
>>> On Wed, Apr 20, 2016 at 2:00 PM, Cecil Westerhof >> >
>>> wrote:
>>>
>>> > How stupid that I did not think about Google Drive. :'-( Here it is:
>>> >
On Wed, 20 Apr 2016 22:21:04 +0200
Cecil Westerhof wrote:
> 2016-04-20 18:27 GMT+02:00 R Smith :
>
> > If you are happy to log in to the server, we could suggest a few
> > great tools - but please note that there is nothing wrong with
> > MySQL as far as web development goes. There is no need to
2016-04-20 22:35 GMT+02:00 Cecil Westerhof :
> 2016-04-20 22:21 GMT+02:00 Scott Robison :
>
>> On Wed, Apr 20, 2016 at 2:00 PM, Cecil Westerhof
>> wrote:
>>
>> > How stupid that I did not think about Google Drive. :'-( Here it is:
>> > https://drive.google.com/file/d/0BzW5q7uL-6z0SDdya2REaFNF
2016-04-20 22:21 GMT+02:00 Scott Robison :
> On Wed, Apr 20, 2016 at 2:00 PM, Cecil Westerhof
> wrote:
>
> > How stupid that I did not think about Google Drive. :'-( Here it is:
> > https://drive.google.com/file/d/0BzW5q7uL-6z0SDdya2REaFNFUVE
> >
> > ?I am very curious.
> >
>
> I downloaded t
2016-04-20 19:27 GMT+02:00 R Smith :
>
>
> On 2016/04/20 6:21 PM, Cecil Westerhof wrote:
>
>> 2016-04-20 18:07 GMT+02:00 R Smith :
>>
>>
>>> On 2016/04/20 6:04 PM, Cecil Westerhof wrote:
>>>
>>> I am thinking about creating a table where a certain field will be a
description, or a key to the
Dear SQLite users,
If you are interested in using SQLite database in modern C++ way
sqlite3cpp( https://github.com/yangacer/sqlite3cpp ) hope to be your
favorite choice.
The sqlite3cpp provides following features:
1. Query with range for-loop and typed parameter binding
2. Create SQL scalar func
2016-04-20 19:21 GMT+02:00 Richard Hipp :
> There will be an opportunity to meet some of the developers of SQLite
> in Eindhoven on 2016-06-24 and in Berlin on 2016-06-27. This can be a
> free public lecture on SQLite or related topics, or just an informal
> get-together over coffee.
>
?I would
2016-04-20 18:27 GMT+02:00 R Smith :
> If you are happy to log in to the server, we could suggest a few great
> tools - but please note that there is nothing wrong with MySQL as far as
> web development goes. There is no need to change to SQLite, what is MySQL
> doing wrong? A major consideration
2016-04-20 18:16 GMT+02:00 Martin Kucej :
> I use phpLiteAdmin. It has served me well.
>
> https://www.phpliteadmin.org/
?Thanks. I will share it with my colleague.
--
Cecil Westerhof
2016-04-20 18:11 GMT+02:00 R Smith :
>
>
> On 2016/04/20 5:56 PM, Cecil Westerhof wrote:
>
>> 2016-04-20 16:07 GMT+02:00 R Smith :
>>
>>
>>> On 2016/04/20 3:31 PM, Cecil Westerhof wrote:
>>>
>>> ?It is still 411 MB. When I am home I will try it on another system also
>>> to
>>> look if there the t
On 2016/04/20 6:21 PM, Cecil Westerhof wrote:
> 2016-04-20 18:07 GMT+02:00 R Smith :
>
>>
>> On 2016/04/20 6:04 PM, Cecil Westerhof wrote:
>>
>>> I am thinking about creating a table where a certain field will be a
>>> description, or a key to the description. Would it be possible to have a
>>> c
For me, source_id = 2016-04-18 15:46:14 eba27d4d17a76884292667d570d542e580ee3e77
Windows 10 1511 Pro, i7-3632QM 2.4Ghz, 16 GB Ram, 1 TB 850 Pro SSD
with secure_delete=0
either
drop table testuniqueuuid;
or the sum of both
delete from testuniqueuuid;
drop table testuniqueuuid;
takes under 2 s
There is ample PHP support, and even Python and the like (see the APSW
suite by Roger Binns for instance).
PHP of course supports also MSSQL and PostGres and the like, there is no
need to be "stuck with MySQL".
As for phpMyAdmin - that's a different story - the strength of
phpMyAdmin is of cour
2016-04-20 18:07 GMT+02:00 R Smith :
>
>
> On 2016/04/20 6:04 PM, Cecil Westerhof wrote:
>
>> I am thinking about creating a table where a certain field will be a
>> description, or a key to the description. Would it be possible to have a
>> constraint on this field that it is an id, that this id
I'm using https://www.phpliteadmin.org/ for this. Great tool and cheap:
free!
2016-04-20 18:12 GMT+02:00 Cecil Westerhof :
> I am blowing the horn for SQLite. ;-) A colleague of mine likes it in
> principal, but he provides web hosting with a database. He has to provide
> his clients with a web
I am blowing the horn for SQLite. ;-) A colleague of mine likes it in
principal, but he provides web hosting with a database. He has to provide
his clients with a web based interface for maintaining there database.
Because of this he thinks he is ?condemned? to MySQL.
Is this true, or would there b
On 2016/04/20 5:56 PM, Cecil Westerhof wrote:
> 2016-04-20 16:07 GMT+02:00 R Smith :
>
>>
>> On 2016/04/20 3:31 PM, Cecil Westerhof wrote:
>>
>> ?It is still 411 MB. When I am home I will try it on another system also to
>> look if there the timing is differently. Is there an upload site you
>> r
On 2016/04/20 6:04 PM, Cecil Westerhof wrote:
> I am thinking about creating a table where a certain field will be a
> description, or a key to the description. Would it be possible to have a
> constraint on this field that it is an id, that this id points to an
> existing record in a description
I am thinking about creating a table where a certain field will be a
description, or a key to the description. Would it be possible to have a
constraint on this field that it is an id, that this id points to an
existing record in a description table?
--
Cecil Westerhof
2016-04-20 16:07 GMT+02:00 R Smith :
>
>
> On 2016/04/20 3:31 PM, Cecil Westerhof wrote:
>
>> 2016-04-20 12:35 GMT+02:00 R Smith :
>>
>>
>>> On 2016/04/20 10:50 AM, Cecil Westerhof wrote:
>>>
>>> The Devs do read the list, and often post, and they will be very
>>> interested in what you have disco
On 20 Apr 2016, at 5:21pm, Cecil Westerhof wrote:
> I want it to point to a record if it is an INT and whem
> it is TEXT it is just the text.
If you could do this in SQL it would be horrible.
Use two fields. One for the INT, the other for the TEXT. The one you're not
using for that row is s
If you upload a file to google drive and later try to replace it with
a different version google drive often corrupts it. Always delete and
upload a new version.
On Wed, Apr 20, 2016 at 4:04 PM, jungle Boogie
wrote:
> On 20 April 2016 at 14:55, Cecil Westerhof wrote:
>> This one I download, un
On Wed, Apr 20, 2016 at 3:31 PM, Cecil Westerhof
wrote:
> >>> ?Do the developers read this list, or should I post a bug report?
>
They do, and it's actually the preferred way to discuss
issues/bugs/performances, etc...
Dr. Hipp even wrote not long ago "bugs" entered would be aggressively
remove
On Wed, Apr 20, 2016 at 3:55 PM, Cecil Westerhof
wrote:
>
> ?This one I download, unpacked and tried. It worked. So it should be
> correct now:
> https://drive.google.com/file/d/0BzW5q7uL-6z0UjFhRWZWSENnZW8/
>
> ?Made with zip.
>
Windows 10 1511 with Feb 2016 updates, x64
i7-6700K 4.00GHz
32
On 2016/04/20 3:31 PM, Cecil Westerhof wrote:
> 2016-04-20 12:35 GMT+02:00 R Smith :
>
>>
>> On 2016/04/20 10:50 AM, Cecil Westerhof wrote:
>>
>> The Devs do read the list, and often post, and they will be very
>> interested in what you have discovered if it is not a system anomaly on
>> your sid
On 20 April 2016 at 14:55, Cecil Westerhof wrote:
> This one I download, unpacked and tried. It worked. So it should be
> correct now:
> https://drive.google.com/file/d/0BzW5q7uL-6z0UjFhRWZWSENnZW8/
Windows 8.1 4 gigs of RAM, dell latitude with i5 process from a few
years ago, lots of tabs a
2016-04-20 12:35 GMT+02:00 R Smith :
>
>
> On 2016/04/20 10:50 AM, Cecil Westerhof wrote:
>
>> 2016-04-20 10:44 GMT+02:00 Dominique Devienne :
>>
>> On Wed, Apr 20, 2016 at 10:36 AM, Cecil Westerhof >> >
>>> wrote:
>>>
>>> I am baffled. Still DELETE before DROP is a lot more efficient. And it
OK, here are a few test results ... 350,000 points with no additional data
... timings with all data in cache and 17 records selected:
#1
CREATE INDEX "pdata_spatial_index_x" ON "pdata"("gx");
CREATE INDEX "pdata_spatial_index_y" ON "pdata"("gy");
file size 24,200 KB, query time ~6.3 ms
#2
CREATE
On Wed, Apr 20, 2016 at 2:49 PM, Jay Kreibich wrote:
> > To attach several memory DBs, it's more like
> >
> > ATTACH DATABASE "file:mem1?mode=memory" as db1;
> > ATTACH DATABASE "file:mem2?mode=memory" as db2;
> > etc... ?DD
>
> There is no requirement to use the URI style file type, you can just
On 20 Apr 2016, at 2:16pm, Wolfgang Enzinger wrote:
> CREATE INDEX "pdata_spatial_index" ON "pdata"("gx","gy");
>
> [snip]
>
> However, EQP also shows that it is only used with the value of gx, not gy:
It would be used if you searched for one x value and a range of y values. If
you do have
Yadav, Rohit wrote:
> I ... pointed SQLITE_TMPDIR, TMPDIR, TMP, TEMP to the newly created directory.
> ... but it looks like sqlite is still using /tmp directory to write temporary
> files.
How exactly did you change the environment variables, and how did you
ensure that the SQLite library sees t
On Wed, Apr 20, 2016 at 2:00 PM, Cecil Westerhof
wrote:
> How stupid that I did not think about Google Drive. :'-( Here it is:
> https://drive.google.com/file/d/0BzW5q7uL-6z0SDdya2REaFNFUVE
>
> ?I am very curious.
>
I downloaded this and opened it with sqlite3.exe shell version 3.11.0.
D:\>
Simon, Gunter,
thanks for your input. I also noticed that an index on (gx,gy) would help on
covering index searches, however as you both noticed as well there are more
fields in this table. But wait - probably for the first step (which points
are located in the region in question anyway?) it might
The "Usability" of an index for a certain set of constraints ends with the
first (in the order mentioned in the index) field with an inequality constraint.
However, and index on (gx,gy) is still be faster for the query shown than just
on (gx), because the value of the second field is read from t
There will be an opportunity to meet some of the developers of SQLite
in Eindhoven on 2016-06-24 and in Berlin on 2016-06-27. This can be a
free public lecture on SQLite or related topics, or just an informal
get-together over coffee.
Private training sessions and/or briefings are also available
Dear group,
since a couple of years now, I'm using SQLite for storing graphic objects
like polygons and lines, with great success. Using the rtree extension
makes spatial queries very efficient.
In my lastest project, however, these objects are just single points
(coordinate pairs). As I understa
On 2016/04/19 10:48 PM, R Smith wrote:
>
>
> On 2016/04/19 8:34 PM, Jarred Ford wrote:
>> Is it possible to create multiple in-memory databases and be able to
>> access tables with a single query between them? For example, select
>> * from db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x =
On 2016/04/20 10:50 AM, Cecil Westerhof wrote:
> 2016-04-20 10:44 GMT+02:00 Dominique Devienne :
>
>> On Wed, Apr 20, 2016 at 10:36 AM, Cecil Westerhof
>> wrote:
>>
>>> I am baffled. Still DELETE before DROP is a lot more efficient. And it
>>> looks that it is not bothered when other programs ar
On 4/20/16, Andy Allord wrote:
> I?m new to sqlite and this is probably something simple I?m overlooking.
>
> I?m working with binaries for 3.9.x on a Mac using Vagrant as a development
> environment with PHP. PHP currently support Sqlite 3.8.x databases and when
> the database is created it is be
Would not the following snippet be useful to return the record ID if the
feature set already exists?
SELECT rec.id
FROM records rec
WHERE
1 = (SELECT SUM(id_f IN (21, 22, 23)) = 3 AND COUNT(*) = 3 FROM
records_features rf WHERE rf.id_r = rec.id)
You would have to have some logic in your calling l
I use phpLiteAdmin. It has served me well.
https://www.phpliteadmin.org/
On 04/20/2016 11:12 AM, Cecil Westerhof wrote:
> I am blowing the horn for SQLite. ;-) A colleague of mine likes it in
> principal, but he provides web hosting with a database. He has to provide
> his clients with a web base
2016-04-20 10:44 GMT+02:00 Dominique Devienne :
> On Wed, Apr 20, 2016 at 10:36 AM, Cecil Westerhof
> wrote:
>
> > I am baffled. Still DELETE before DROP is a lot more efficient. And it
> > looks that it is not bothered when other programs are running (most of
> > the time). I would think that a
On Wed, Apr 20, 2016 at 10:36 AM, Cecil Westerhof
wrote:
> I am baffled. Still DELETE before DROP is a lot more efficient. And it
> looks that it is not bothered when other programs are running (most of
> the time). I would think that a DROP should take the least time:
>
I agree. That's weird. N
2016-04-19 15:27 GMT+02:00 Olivier Mascia :
> > Le 19 avr. 2016 ? 14:49, Cecil Westerhof a
> ?crit :
> >
> > SECURE_DELETE
>
> Are you aware of the net effect of SQLITE_SECURE_DELETE?
>
> https://www.sqlite.org/compile.html#secure_delete
>
> The documentation talks about a "small performance pena
On Wed, Apr 20, 2016 at 10:22 AM, Dominique Devienne
wrote:
> On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote:
>>
>> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
>>
>> > Is it possible to create multiple in-memory databases and be able to
>> access tables with a single query between them
On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote:
>
> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
>
> > Is it possible to create multiple in-memory databases and be able to
> access tables with a single query between them?
> > For example, select * from db1.dbo.table1 db1 join db2.dbo.tabl
On 20 Apr 2016, at 9:36am, Cecil Westerhof wrote:
> On a clean system:
> SECURE_DELETE=1, DROP ONLY 17 minutes
> SECURE_DELETE=1, DELETE and DROP14 minutes
> SECURE_DELETE=0, DROP only 4? minutes
> SECURE_DELETE=0, DELETE and DROP ? minute
>
> [...]
>
> I am baffl
I?m new to sqlite and this is probably something simple I?m overlooking.
I?m working with binaries for 3.9.x on a Mac using Vagrant as a development
environment with PHP. PHP currently support Sqlite 3.8.x databases and when the
database is created it is being created as a 3.9.x. Is there anywa
On 4/19/16, Yadav, Rohit wrote:
> Hello,
>
> I got this error "sqlite3.OperationalError: database or disk is full? and I
> researched about it and created another directory that has lot of space and
> pointed SQLITE_TMPDIR, TMPDIR, TMP, TEMP to the newly created directory. I
> also used sqlitecur.
On Apr 20, 2016, at 3:22 AM, Dominique Devienne wrote:
> On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote:
>>
>> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
>>
>>> Is it possible to create multiple in-memory databases and be able to
>> access tables with a single query between them?
>
Am 19.04.2016 um 20:34 schrieb Jarred Ford:
> Is it possible to create multiple in-memory databases and be able to access
> tables with a single query between them? For example, select * from
> db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x.
Yes, that's possible over appropriate Fi
51 matches
Mail list logo
