Cem Dayanik (Ibtech-Software Infrastructure) wrote:
> CREATE TABLE InstanceReferences (InstanceAddress INTEGER, RefByAddress
> INTEGER)
> CREATE TABLE Instances (TypeId INTEGER, Address INTEGER)
> CREATE TABLE Types (Id INTEGER, Name TEXT, MethodTable INTEGER, Count INT,
> TotalSize INTEGER)
>
>
"Another option is to create an "Unknown" customer, and link any new orders to
it. You can easily change that parent-id on the order later."This solution
seems not work (especially in my case) because it is easy to have more than one
unknown customer. Then I can't decide who orders what later.
On Tue, Apr 4, 2017 at 9:52 PM, Jens Alfke wrote:
>
>> On Apr 4, 2017, at 8:33 PM, Pavel Volkov wrote:
>>
>> bash it's Bourne again shell. Not Bourne shell. Bash is more then POSIX
>> shell.
>
> Yes, that’s what they said. The Bourne shell is ‘sh’.
>
>> And you forgot the FreeBSD in your listing.
> On Apr 4, 2017, at 8:33 PM, Pavel Volkov wrote:
>
> bash it's Bourne again shell. Not Bourne shell. Bash is more then POSIX
> shell.
Yes, that’s what they said. The Bourne shell is ‘sh’.
> And you forgot the FreeBSD in your listing. As example. It does not use bash
> at all.
It doesn’t com
Hello.
bash it's Bourne again shell. Not Bourne shell. Bash is more then POSIX
shell.
And you forgot the FreeBSD in your listing. As example. It does not use
bash at all.
Thank you.
On Apr 4, 2017 4:34 PM, "Gary R. Schmidt" wrote:
> On 04/04/2017 23:20, Richard Hipp wrote:
>
>> On 4/4/17, Pavel
On 4/4/17, Richard Hipp wrote:
> On 4/4/17, Ben Newberg wrote:
>> I've noticed with 3.18.0 that it's possible to make a database increase
>> in
>> size after running pragma integrity_check (which returns "ok") and then
>> running vacuum.
>
> I can now repro the behavior and have bisected to this
On 4/4/17, Ben Newberg wrote:
> I've noticed with 3.18.0 that it's possible to make a database increase in
> size after running pragma integrity_check (which returns "ok") and then
> running vacuum.
I can now repro the behavior and have bisected to this check-in:
https://www.sqlite.org/src/timeli
Hi Peter,
Wrapping the bbox was solely for the purpose of additional (and optional)
performance. At the moment, this column would be optional and used instead of
the geopackage geometry in some situations (e.g. improve rtree indexing by
avoiding to create the bbox for every geometry). The Geopa
Can you email me the database that does this?
On 4/4/17, Ben Newberg wrote:
> I've noticed with 3.18.0 that it's possible to make a database increase in
> size after running pragma integrity_check (which returns "ok") and then
> running vacuum.
>
> Alternatively, vacuuming without running pragma
I've noticed with 3.18.0 that it's possible to make a database increase in
size after running pragma integrity_check (which returns "ok") and then
running vacuum.
Alternatively, vacuuming without running pragma integrity_check first keeps
the database the same size as before.
The page size on the
If you're creating GeoPackages with the F.3 RTREE Spatial Indexes
extension, you do not "wrap" a bounding box. You need to define 5
functions from SQL/MM -- ST_MinX, ST_MaxX, ST_MinY, ST_MaxY and
ST_IsEmpty -- that take a geometry blob as input and return (for the
first four) a floating point n
On Tue, Mar 28, 2017 at 11:26 AM, Max Vlasov wrote:
>
>
> So, what is the maximum reasonable value of estimatedCost that will not
> turn sqlite into possible overflow errors while telling at the same time
> that I consider some variant very, very expensive? Or maybe changing cheap
> from 1 to 0 w
I hate to be critical of Dr Hipp, but this commit stinks. Even if using the
sqlite3 shell isn't the blessed way of producing a backup, I'm sure a lot
of folks prefer it to the online backup API. It's this simple:
"echo .dump | sqlite3 my_db.db | gzip > my_db.sql.gz"
That's beautiful.
And now it
oops
you need to select the string length from the column width
select substring('', 1, 16 - length(printf("%2.f",
price))) || printf("%2.f", price) from prices
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonfor
Just shooting out so no time to test. But could you try something like
select substring('', 1, length(printf("%2.f", price))) ||
printf("%2.f", price) from prices
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sanderson
On Tue, Apr 4, 2017 at 3:47 PM, Hans M. van der Meer
wrote:
> Simon, thanks.
> Now at last, I know how to continue.
>
But SQLite itself ships with a portable version of printf too.
So you can convert your integer or real typed columns into text typed ones
for display, directly in SQL, as an alt
Simon, thanks.
Now at last, I know how to continue.
2017-04-04 15:03 GMT+02:00 Simon Slavin :
>
> On 4 Apr 2017, at 11:25am, Hans M. van der Meer
> wrote:
>
> > I am building a simple bookkeeping.
> > With PHP and SQLite i now have tables and views with columns for values
> and
> > prices: not n
On 04/04/2017 23:20, Richard Hipp wrote:
On 4/4/17, Pavel Volkov wrote:
The "+ =" operator works as you would expect in bash only.
And it causes an error in the Bourne shell, for example.
You have piqued my curiosity. Who is still using Bourne shell instead
of the Bourne-again shell (bash)?
On 4/4/17, Pavel Volkov wrote:
> The "+ =" operator works as you would expect in bash only.
> And it causes an error in the Bourne shell, for example.
You have piqued my curiosity. Who is still using Bourne shell instead
of the Bourne-again shell (bash)? Bash has been with us now for like
three
On 4/3/17, Stadin, Benjamin wrote:
> Hi,
>
> Is there a hook which allows to get notified as soon as it’s save to modify
> a db connection after (or as alternative to) sqlite3_update_hook was
> triggered?
There is no such callback built into SQLite. But you can add one by
putting a wrapper aroun
On 4 Apr 2017, at 11:25am, Hans M. van der Meer wrote:
> I am building a simple bookkeeping.
> With PHP and SQLite i now have tables and views with columns for values and
> prices: not nicely aligned because decimal values are aligned different
> from values that are interpreted as integers.
Nu
Hello there,
I am trying to find a memory leak with MemoScope.
It is using sqllite.
Memoscope has some issue to find the problem so I am actually querying the data.
CREATE TABLE InstanceReferences (InstanceAddress INTEGER, RefByAddress INTEGER)
CREATE TABLE Instances (TypeId INTEGER, Address INTE
Hello all,
* Short story:
To support better security through binding, we would like to request a new
C/C++ API function similar to sqlite3_exec(), however it will take a prepared
statement instead of an sql string.
* Long story:
We finally allowed a user string input directly into our database
Hi,
Is there a hook which allows to get notified as soon as it’s save to modify a
db connection after (or as alternative to) sqlite3_update_hook was triggered?
The background to this question is that I’m trying to prepare a proposal for
Geopackage. And one of the questions is if it’s possible t
Hi users,
I am building a simple bookkeeping.
With PHP and SQLite i now have tables and views with columns for values and
prices: not nicely aligned because decimal values are aligned different
from values that are interpreted as integers.
I like to create reports in which the column of prices an
Hello.
Please, replace the "+ =" operators in the configure.ac file with a
more compatible way of combining strings.
The "+ =" operator works as you would expect in bash only.
And it causes an error in the Bourne shell, for example.
Please, see this patch:
--- configure.ac.orig 2017-04-03 12:16:
26 matches
Mail list logo
