for Widnows only ?
Not sure that's even related but thanks for double checking.
Best Regards
On Wed, Feb 25, 2015 at 1:40 PM, Richard Hipp wrote:
> On 2/25/15, Andrea Giammarchi wrote:
> > Dear All,
> > it looks like we are back in town with '\n' at the end of a line **even
&g
denote line breaks. However, implementors should be aware that
some implementations may use other values.
On Wed, Feb 25, 2015 at 8:48 AM, Andrea Giammarchi <
andrea.giammarchi at gmail.com> wrote:
> Dear All,
> it looks like we are back in town with '\n' at the end of a lin
Dear All,
it looks like we are back in town with '\n' at the end of a line **even
in CSV** mode.
Can anyone please confirm me (ccing me since apparently I'm not part of
this ML) that SQLite no longer forces RFC4180 \r\n ?
Thank you!
On Sun, Aug 17, 2014 at 7:28 PM, Andrea Giammarchi
Coming from a long conversation with tests in place too, it looks like
SQLite CLI is flushing errors right away in Linux, but until undefined
amount of buffer in OSX or Windows, where in latter one nothing is shown
until `.quit` is called [1]
The only way to have a consistent behavior seems to be
anation ?
> one tutorial (eventuali on eclipse) ?
>
> thanks.
>
> olivier BOURQUARD.
>
> i subcrib to your site.
>
> nb : i kan send you my "VirtualBoxe".
>
>
> Le 18/08/2014 14:18, Richard Hipp a écrit :
>
>> On Sun, Aug 17, 2014 at 2:28 PM, And
I wonder if this is meant to be or not, it seems that starting from version
`3.8.6` sqlite3-cli/shell now uses only \r\n strings instead of using the
default new line in the OS.
This broke badly a spawned parser of mine but I'd like to know the
rationale behind this choice, it does not feel right
Eugene Wee wrote:
Not at all (if I correctly understand what you're trying to say).
For example, there exists a SQLite extension in PHP (which comes
bundled by default in PHP5, but currently does not support SQLite3).
pecl, PDO extensions allows PHP to use SQLITE Version 3.X too :-)
If anyone is interested on Modified Preorder Tree Traversal Algorithm
and has PHP5 on its PC, here is the class with an example file:
class: http://www.devpro.it/code/85.html
example_file: http://www.devpro.it/examples/TEST_SqliteMPTTA.zip
Thank you for debugging.
Regards,
Andrea Giammarchi
John LeSueur wrote:
instead of if, use case when then end statement:
UPDATE ||table ||
SETlft=lft + case when lft<".$nodes["n1lft"]."
then $inc else -$desc end,
rgt=rgt + case when rgt<".$nodes["n1lft"]." then
$inc else -$desc end
Hi, I am trying to develop a php class that should implement MPTTA on
SQLITE and results are great!!
BUT, I'm not finding any way to move a branch under another , I' ve just
moved successfully a unique branch on same level on another but anymore ...
On MYSQL someone use this sintax
|SELECT
Maybe you should convert in base64 your file than apply some crypting
and decrypt and riencode on the fly while launching your application ...
is it possible ?
liigo wrote:
No ways to avoid it? I don't want people to get my Datas in my
Database file.
has a problem or want to tell me
some features to add he/she should write me directly on my email: andrea
[ at ] 3site [ --- dot --- ] it with subject prefix = [SQLITE2M]
Thank you, I hope this little program will be usefull ( now that it
should work ) .
Regards,
Andrea Giammarchi
SQLITE 2
it and it works as well as on PC db files :-)
Here is the link
http://cmslim.3site.it/download.php?id=7
560 Kb , but host is really slow ... I 'll change soon, sorry.
( or maybe I will put final functionally program on sourceforge ... )
Regards,
Andrea Giammarchi
why it doesn't work on your windows PC, I am sorry :-(
Any other comment from other ?
That flash interface will be used with a PHP5 class file to manage, with
user and password, your online sqlite files too, should be interesting ?
Regards,
Andrea Giammarchi
Noel Frankinet wrote:
windows 2000 prof.
well, I have tried on windows 2000 prof. SP4 right now ... it works
perfectly, are you sure to have opened an uncorrupted sqlite *version 2
*file ???
Really strange if you are sure, anyone should tell me if this program
works correctly ?
See you,
Thank you Noel Frankinet for this repot , I just use this application to
manage my sqlite database files ... well, Windows XP SP2 and flash
player 7, no problema with a lot of database files ..
-very heavy download
I am working to have a better host ... I am sorry, I know this is
slow ...
hink about this little program, thank you :-)
http://cmslim.3site.it/download.php?id=6
Andrea Giammarchi
Hi everybody,
I'm veiwing that SQLite has new and updated versions every few
months, you are doing a very good work but I wonder if next release oh
PHP5 ( > 5.0.1 ) will has at least version 3.0 of this wonderful
database engine :-)
Regards,
Andrea Giammarchi
--
No vi
- Original Message -
From: "Simon Berthiaume"
> Have you tried to change the order of the conditions in the WHERE
> clause? I don't know the internal working of SQLite so they might
> actualy give worst results. You can try something like that:
>
> SELECT date_ext.mydate as MyDate,
Hi All,
I'm doing some tests with SQLite ( 2.8.14 ) against MySQL ( 4.1.3 beta )
with these 2 tables:
date_ext ( id INTEGER PRIMARY KEY, mydate DATE not null )
city_ext ( id INTEGER PRIMARY KEY, city CHAR( 2 ) )
number_ext ( id INTEGER PRIMARY KEY, mydate INTEGER not null, city
INTEGER(2) not
20 matches
Mail list logo
