Hi, Richard,
just to let you know, I have continued to use sqlar rather than tar.gz
for my personal use.
I found a problem with recursive symlinks.
For example, I have a copy of sqliteodbc-0.9994.tar.gz which has a
symlink source -> . Note, the Gnome Archive Manager has a nice arrow
icon, but se
On Fri, 10 Feb 2017 20:57:34 +0100
Dominique Devienne wrote:
> the view itself calls printf.
I see now. Your request is very specific: to support a thousands
separator in the SQL printf. You don't want to write a UDF, and you
don't want to use any facilities above the API (in C or other).
I
> On Feb 10, 2017, at 2:45 AM, Dominique Devienne wrote:
>
> Honestly Clemens? There wouldn't be a built-in printf() and substr() etc...
> if that was the case.
Not really. Those aren’t necessarily intended to format data for display, and
I’ve never used them for that. For example I might use
Dominique Devienne wrote:
> On Fri, Feb 10, 2017 at 6:53 PM, Stephen Chrzanowski
> wrote:
>> The date and time are stored as a number, not
>> "Friday, February 10, 2017 12:43:33pm".
>
> And that's exactly why SQLite has date and time functions.
> Notably the one converting a number of seconds sinc
On Fri, Feb 10, 2017 at 7:40 PM, James K. Lowden
wrote:
> On Fri, 10 Feb 2017 10:46:24 +0100
> Dominique Devienne wrote:
>
> > Couldn't SQLite's built-in printf gain a thousand-separator formatting
> > argument, which doesn't need to be locale aware or could be even
> > explicit after the arg?
>
On Fri, 10 Feb 2017 10:46:24 +0100
Dominique Devienne wrote:
> Couldn't SQLite's built-in printf gain a thousand-separator formatting
> argument, which doesn't need to be locale aware or could be even
> explicit after the arg?
...
> This is data meant to be viewed with any SQLite client, so kind
On Fri, Feb 10, 2017 at 6:56 PM, Dominique Devienne
wrote:
> On Fri, Feb 10, 2017 at 6:21 PM, Jens Alfke wrote:
>
>> > On Feb 10, 2017, at 5:59 AM, Dominique Devienne
>> wrote:
>> >
>> > 2) ask DRH to consider enhancing SQLite's built-in printf() to support
>> it out-of-the-box.
>>
>> I disagre
On Fri, Feb 10, 2017 at 6:53 PM, Stephen Chrzanowski
wrote:
> Bringing in "Other Database Engines do it!" discussion [...]
>
When did I do that?
> Any element that is to be portrayed to the users screen should be handled
> by whatever UI engine is displaying the information, not something that
On Fri, Feb 10, 2017 at 6:21 PM, Jens Alfke wrote:
> > On Feb 10, 2017, at 5:59 AM, Dominique Devienne
> wrote:
> >
> > 2) ask DRH to consider enhancing SQLite's built-in printf() to support
> it out-of-the-box.
>
> I disagree; this is feature bloat.
>
Wow. Feature bloat from adding *1 characte
Bad design begins where you start throwing formatting functions in a SQL
call that could be used as a calculated value. You request information for
text, numbers, or blobs of binary data. Nothing more, nothing less,
because it is assumed that you're going to do something productive with the
numbe
On Fri, Feb 10, 2017 at 11:21 AM, Jens Alfke wrote:
>
> > On Feb 10, 2017, at 5:59 AM, Dominique Devienne
> wrote:
> >
> > 2) ask DRH to consider enhancing SQLite's built-in printf() to support it
> > out-of-the-box.
>
> I disagree; this is feature bloat. SQLite is an embedded database, and the
> On Feb 10, 2017, at 5:59 AM, Dominique Devienne wrote:
>
> 2) ask DRH to consider enhancing SQLite's built-in printf() to support it
> out-of-the-box.
I disagree; this is feature bloat. SQLite is an embedded database, and the host
app can do whatever it wants with the data, such as formattin
On Fri, Feb 10, 2017 at 4:44 PM, Hick Gunter wrote:
> The beauty of SQLite lies in its user extensability. If you want a
> presentation layer function in SQLite you can always write your own custom
> function, without forcing your specific needs on the community as a whole.
>
> e.g. print_money(
The beauty of SQLite lies in its user extensability. If you want a presentation
layer function in SQLite you can always write your own custom function, without
forcing your specific needs on the community as a whole.
e.g. print_money( [, ])
with a check that is actually an integer (and not a f
On Fri, Feb 10, 2017 at 2:41 PM, Arjen Markus
wrote:
> > -Original Message-
> > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf
> > Of Simon Slavin
> > Sent: Friday, February 10, 2017 2:36 PM
> > To: SQLite mailing list
> > Subject: Re: [sqlite] thousa
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf
> Of Simon Slavin
> Sent: Friday, February 10, 2017 2:36 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] thousand separator for printing large numbers
>
>
> On 10 Feb 2017, at 1
On 10 Feb 2017, at 1:25pm, Arjen Markus wrote:
> Not entirely, in German-spoken countries the apostrophe (') is often used as
> a thousands-separator.
That’s Switzerland, right ? Not a member of the EU. I didn’t know it covered
other countries too. Thanks.
To make it worse still, the ISO
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf
> Of Simon Slavin
>
> Just to add to what Clemens wrote, you would at least need ways of doing
> comma-
> separation for thousands, dot-separation for thousands, and space-separator
On 10 Feb 2017, at 10:26am, Clemens Ladisch wrote:
>> Couldn't SQLite's built-in printf gain a thousand-separator formatting
>> argument, which doesn't need to be locale aware
>
> Thousand separators _are_ locale specific.
Just to add to what Clemens wrote, you would at least need ways of doin
2017-02-09 18:46 GMT+01:00 Roger Binns :
> On 08/02/17 11:41, Cecil Westerhof wrote:
> > OK, glad to help. What should I do?
>
> It is nicest if whatever software/tools you already have also has some
> sort of testing (ideally automated, but a manual checklist works too).
>
> Then run the testing
Hi,
I want to create sqlite database, without any dependency platform
resolve in a pcl project.
Thanks,
Bhaskar.R
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite
On Fri, Feb 10, 2017 at 11:26 AM, Clemens Ladisch
wrote:
> Dominique Devienne wrote:
> > But there's got to be a better way, no?
>
> A database stores data. Formatting the data for the user is not the
> job of the database but of the actual application.
Honestly Clemens? There wouldn't be a bu
Dominique Devienne wrote:
> But there's got to be a better way, no?
A database stores data. Formatting the data for the user is not the
job of the database but of the actual application.
> Couldn't SQLite's built-in printf gain a thousand-separator formatting
> argument, which doesn't need to be
There's
http://sqlite.1065341.n5.nabble.com/printf-with-thousands-separator-td85022.html
And my feeble attempt below. But there's got to be a better way, no?
What would be the shortest and/or most efficient way to do this in SQL?
Couldn't SQLite's built-in printf gain a thousand-separator formatt
24 matches
Mail list logo