Clemens,
On Fri, Jan 29, 2016 at 3:19 AM, Clemens Ladisch wrote:
> Igor Korot wrote:
>> 1>odbccp32.lib(dllload.obj) : error LNK2019: unresolved external
>> symbol __imp___vsnprintf referenced in function
>> _StringVPrintfWorkerA at 20
>
> Looks like a bug in the MSVC libraries:
>
On Fri, Jan 29, 2016 at 8:59 PM, Cecil Westerhof
wrote:
>
> > However, I've run into a few problems, so I'm offering my findings and
> > fixes.
> >
> > The first, line 3, you've got a reference to a script that doesn't exist
> > AFAIK. You should maybe put a check to see if the file exists
Thanks for the input Simon. I'm not sure why that'd end up on this
particular machine. Must be the Author of the mod doing something
different for preferences, as this is the only directory that shows up.
The contents of the directories were just preference files. I don't think
it'll affect
The partition portion failed not because of multiple references to / but
multiple references to tempfs. Maybe set the constraint to not only the
partition type but also the mount point?
On Fri, Jan 29, 2016 at 7:14 PM, Stephen Chrzanowski
wrote:
> This is going to be useful for me for a couple
This is going to be useful for me for a couple of reasons. First, I've got
a machine at work that mysteriously fills up, and more importantly, I can
monitor my Minecraft server at home. ;)
However, I've run into a few problems, so I'm offering my findings and
fixes.
The first, line 3, you've
I wrote the following article:
??
Use Bash to Store Disc Info in SQLite
??
https://www.linkedin.com/pulse/use-bash-store-disc-info-sqlite-cecil-westerhof
?No rocket science, but I thought it could be interesting.
?
--
Cecil Westerhof
At 16:23 29/01/2016, you wrote:
>Note that the fractional part in Julian day represents time-of-day
>since noon, not since midnight.
Ah yes, I often forget about this point. Sorry for incorrect lead.
)
>
?Yeah, I saw that. I went back to:
dateTEXT NOT NULL DEFAULT CURRENT_DATE
?
> Personally, I prefer cast(strftime('%Y%m%d', 'now') as int) - in other
> words, storing calendar dates as integers like 20160129.
>
?That is a nice one. Maybe I'll change it again. ;-)
--
Cecil Westerhof
2016-01-29 14:39 GMT+01:00 Dominique Devienne :
> On Fri, Jan 29, 2016 at 1:53 PM, Cecil Westerhof
> wrote:
>
> > 2016-01-29 10:12 GMT+01:00 Richard Hipp :
> > > On 1/29/16, Cecil Westerhof wrote:
> > > > In H2 I can find records containing non-ascii characters with:
> > > > SELECT *
> > >
On Fri, Jan 29, 2016 at 1:53 PM, Cecil Westerhof
wrote:
> 2016-01-29 10:12 GMT+01:00 Richard Hipp :
> > On 1/29/16, Cecil Westerhof wrote:
> > > In H2 I can find records containing non-ascii characters with:
> > > SELECT *
> > > FROM
> > > WHERE STRINGENCODE() LIKE '%\\u%'
> > >
>
2016-01-29 10:20 GMT+01:00 Richard Hipp :
> On 1/29/16, Cecil Westerhof wrote:
> > In h2 I can search for words with:
> > quote REGEXP CONCAT('(\W|^)', :search_string, '(\W|$)')
> >
> > Is something like that also possible with SQLite?
>
> SQLite does not have a REGEXP operator enabled by
2016-01-29 10:12 GMT+01:00 Richard Hipp :
> On 1/29/16, Cecil Westerhof wrote:
> > In H2 I can find records containing non-ascii characters with:
> > SELECT *
> > FROM
> > WHERE STRINGENCODE() LIKE '%\\u%'
> >
> > Is something like this also possible with SQLite?
>
> Perhaps
===
...you must fsync the containing directory...
===
Is there an Sqlite option to achieve that?
In fact, to summarise:
Suppose I would like to maximise my chances of avoiding the 'Lost Post-It'
problem described above.
What are _all_ the Sqlite compile-time options, and their values, needed
On Thu, 28 Jan 2016 19:18:06 -0500
"Keith Medcalf" wrote:
>
> When you create a table thusly:
>
> create table x (x primary key, y, z);
>
> you are creating a rowid table with columns x, y, an z. You are also saying
> that you want x to be the primary key. Therefore, you will get a table
dar dates as integers like 20160129.
--
Igor Tandetnik
In h2 I can search for words with:
quote REGEXP CONCAT('(\W|^)', :search_string, '(\W|$)')
Is something like that also possible with SQLite?
--
Cecil Westerhof
In H2 I can find records containing non-ascii characters with:
SELECT *
FROM
WHERE STRINGENCODE() LIKE '%\\u%'
Is something like this also possible with SQLite?
--
Cecil Westerhof
2016-01-29 8:39 GMT+01:00 Jean-Christophe Deschamps :
> At 08:28 29/01/2016, you wrote:
>
>> For storing a date I probably could use strftime('%J'). But I would like
>> to
>> store it as an INT. But I see no way to cast a float to an int. Is that
>> not
>> possible?
>>
>
> select
Igor Korot wrote:
> 1>odbccp32.lib(dllload.obj) : error LNK2019: unresolved external
> symbol __imp___vsnprintf referenced in function
> _StringVPrintfWorkerA at 20
Looks like a bug in the MSVC libraries:
On Fri, 29 Jan 2016 01:34:01 +0200
R Smith wrote:
>
> I think the dictionary would be faster for this use-case (mostly cause
> it runs in-memory and we do not require all the DB data guarantees for
> the initial sort). However, the fastest way in SQL would be to use a
> temporary table, do
At 08:28 29/01/2016, you wrote:
>For storing a date I probably could use strftime('%J'). But I would
>like to
>store it as an INT. But I see no way to cast a float to an int. Is
>that not
>possible?
select cast(julianday('now') as int)
should do what you want.
To store date and time at the moment I use:
datetimeINT NOT NULL DEFAULT (strftime('%s'))
For storing a date I probably could use strftime('%J'). But I would like to
store it as an INT. But I see no way to cast a float to an int. Is that not
possible?
Or is it better just keeping to use:
Hi,
I have a query where I select 20 random distinct rows.
SELECT DISTINCT formulas.pinyin, formulas.majorcategory,
majorfcategory.item_name
FROM formulas
JOIN majorfcategory ON majorfcategory.id=formulas.majorcategory
ORDER BY RANDOM() LIMIT 20
Each row contains a major category id,
Hello Igor,
I'm probably go the opposite direction and make sure everything is
built /MDd or /MD. Basically dynamic link the whole thing. It means
all of your projects need to be rebuilt using the same RTL though.
You just don't want 1/2 to be /MT and the other 1/2 to be /MD.
C
Hi,
I have a query where I select 20 random distinct rows.
SELECT DISTINCT formulas.pinyin, formulas.majorcategory,
majorfcategory.item_name
FROM formulas
JOIN majorfcategory ON majorfcategory.id=formulas.majorcategory
ORDER BY RANDOM() LIMIT 20
Each row contains a major category id,
> > You could achieve the same result as follows:
> >
> > create table x (x, y, z);
> > create unique index pk_x_x on x(x);
> >
> > except that now you have given the index on x an explicit name and one
> does not have to be manufactured for you.
> >
>
> I checked these indexes gets created even
On 1/29/16, Cecil Westerhof wrote:
> In h2 I can search for words with:
> quote REGEXP CONCAT('(\W|^)', :search_string, '(\W|$)')
>
> Is something like that also possible with SQLite?
SQLite does not have a REGEXP operator enabled by default. However,
if you add the
On 1/29/16, Cecil Westerhof wrote:
> In H2 I can find records containing non-ascii characters with:
> SELECT *
> FROM
> WHERE STRINGENCODE() LIKE '%\\u%'
>
> Is something like this also possible with SQLite?
Perhaps something like this:
SELECT * FROM WHERE GLOB
On 2016/01/28 11:44 PM, Yannick Duch?ne wrote:
> On Thu, 28 Jan 2016 22:08:02 +0200
> R Smith wrote:
>
> Indeed, I was misunderstanding. Are these indexes visible? Is there
> any relation with the ones I see from sqlitebrowser?
If you mean you are looking at the DB schema and seeing
29 matches
Mail list logo