Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jens Alfke
> On Mar 20, 2017, at 3:38 PM, Jaime Stuardo wrote: > > That is why I suspect about SQLite3 to be really multiplatform. Why can my > own C++ program, that is not small, be successfully compiled and then run in > the machine? Why cannot SQLite source code? You’re using a

Re: [sqlite] No public bug tracker?

2017-03-20 Thread Simon Slavin
On 21 Mar 2017, at 2:25am, Yuri wrote: > Does this mean that this issue will be fixed: Not necessarily. It does mean that the development team will know about it. They may decide it’s not a bug, or that it’ll take a long time to fix, or have to decide whether to change the

Re: [sqlite] No public bug tracker?

2017-03-20 Thread Yuri
On 03/20/2017 17:11, Simon Slavin wrote: You can report bugs by posting here. The development team will see them. It sometimes takes a little time to get a reaction while they discuss things between themselves to figure out what to do. Does this mean that this issue will be fixed: > A few

Re: [sqlite] No public bug tracker?

2017-03-20 Thread Yuri
On 03/20/2017 17:20, Joshua J. Kugler wrote: If you go here: https://www.sqlite.org/src/login You can see you can log in (if you have an account), or: "Visitors may enter anonymous as the user-ID with the 8-character hexadecimal password shown below." sqlite.org/src/login shows that I am

Re: [sqlite] No public bug tracker?

2017-03-20 Thread Joshua J. Kugler
On Monday, March 20, 2017 5:00:21 PM AKDT Yuri wrote: > Your bug tracker http://www.sqlite.org/src/rptview?rn=1 doesn't accept > public submissions. > A few weeks ago I reported (in this ML) the bug with blob handle being > invalidated by the writes into unrelated tables. > fossil timeline doesn't

[sqlite] configure --enable-shared doesn't build shared libraries

2017-03-20 Thread Yuri
Configure file says: > --enable-shared[=PKGS] build shared libraries [default=yes] However, shared library isn't built by default. This command: $ ./configure --enable-shared && gmake doesn't build it either. Yuri ___ sqlite-users mailing

Re: [sqlite] No public bug tracker?

2017-03-20 Thread Simon Slavin
On 21 Mar 2017, at 12:00am, Yuri wrote: > Isn't it better to have a separate bug report for every issue? You can report bugs by posting here. The development team will see them. It sometimes takes a little time to get a reaction while they discuss things between themselves

[sqlite] No public bug tracker?

2017-03-20 Thread Yuri
Your bug tracker http://www.sqlite.org/src/rptview?rn=1 doesn't accept public submissions. A few weeks ago I reported (in this ML) the bug with blob handle being invalidated by the writes into unrelated tables. fossil timeline doesn't show this bug as fixed, and the above bug site doesn't show

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jaime Stuardo
Thanks a lot... I have finally got it to compile (DLL was generated), but a lot of warnings appeared. Warnings of all of this kind: "warning C4244: 'function' : conversion from 'i64' to 'int', possible loss of data c:\WorkingFolder\Proyectos\Lean\RFID\SQLite3\btree.c " " warning C4244:

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Deon Brewis
Ahh, ok, you're not actually trying to target Windows RT - you're trying to target Windows CE. That makes (a LOT) more sense. The technical problem you have is that you're running into a Windows RT error there. You'll get the same behavior simply if you do this: C:\test>copy con test.c

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jim Borden
Oh, you are talking about WinCE? I don’t think you should be thinking in terms of “ARM vs non-ARM” but rather “X platform vs Y platform.” As others have noted, sqlite obviously runs on ARM and the issue is not with sqlite but with the way you are trying to compile it or the platform you are

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jaime Stuardo
I use to develop mobile applications for years using VS 2008, and in fact, I have just developed a MFC C++ application that runs in the ARM machine without problem. I need to use SQLite3 for my application. That is why I need to compile it. > On 20 Mar 2017, at 23:17, Jaime Stuardo

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jaime Stuardo
When I build my own program using Visual Studio 2008 IDE to be run in the device, it compiles perfectly and also it runs perfectly in the machine. So there is nothing wrong with that. I tried to compile sqlite3.c using the same command line parameters I saw in project properties in VS2008

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Hugo Beauzée-Luyssen
> On 20 Mar 2017, at 23:17, Jaime Stuardo wrote: > > Thanks all who answered. > > Yes... it seems a MSVC limitation, however, it is very strange. I am using > Visual Studio 2008 which does support ARM compilation. I did that, adding > some compiler switches for target

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Deon Brewis
"That suggests me that the code is prepared for MSVC also, but it is not actually." The SQLITE code works just fine on an MSVC build. Have been using it for many years. What platform are you targeting? The MSVC ARM compiler is only meant for Windows RT devices - is that really what you're

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jaime Stuardo
Thanks all who answered. Yes... it seems a MSVC limitation, however, it is very strange. I am using Visual Studio 2008 which does support ARM compilation. I did that, adding some compiler switches for target WIN32_CE but I got million of warnings, of this type: sqlite3.c(166) : warning

Re: [sqlite] RIGHT JOIN! still not supported?

2017-03-20 Thread Chris Locke
Sqlite is public domain, so feel free to add the necessary code, and once approved, it'll get added to the main code. Thanks, Chris On 20 Mar 2017 8:09 p.m., "PICCORO McKAY Lenz" wrote: > i got this > > Query Error: RIGHT and FULL OUTER JOINs are not currently

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Joseph Stockman
This is a Visual Studio/Microsoft issue. We have been building SQLite on ARM 7 and 9 for almost ten years across a wide variety of (non-Microsoft) operating systems. V. From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Hugo Beauzée-Luyssen
Hi, > On 20 Mar 2017, at 22:24, Jaime Stuardo wrote: > > Hello, > > I have finally given up. After almost all day trying to compile SQLite > amalgamated source code files for ARM platform I got the conclusion that > SQLite is not for ARM platform, even when

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Eric Sink
You are encountering a limitation of the compiler you are using, not a limitation of SQLite (which compiles for ARM just fine). The error message is telling you that Microsoft does not support desktop applications compiled for ARM. What environment are you trying to compile for? -- E On Mon,

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jim Borden
That error has nothing to do with SQLite, really. SQLite is deployed on ARM platforms and ships as a system library on iOS. It sounds like you are running into this -> https://stackoverflow.com/questions/11151474/can-arm-desktop-programs-be-built-using-visual-studio-2012 Keep in mind that

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Christian Schmitz
> Am 20.03.2017 um 22:24 schrieb Jaime Stuardo : > > Hello, > > I have finally given up. After almost all day trying to compile SQLite > amalgamated source code files for ARM platform I got the conclusion that > SQLite is not for ARM platform,… Really? I do that now for

[sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jaime Stuardo
Hello, I have finally given up. After almost all day trying to compile SQLite amalgamated source code files for ARM platform I got the conclusion that SQLite is not for ARM platform, even when documentation says the contrary. I have VS 2008 and I tried to compile some C++ wrappers out there

[sqlite] RIGHT JOIN! still not supported?

2017-03-20 Thread PICCORO McKAY Lenz
i got this Query Error: RIGHT and FULL OUTER JOINs are not currently supported Unable to execute statement still today in 21 ts century? Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com ___ sqlite-users mailing list

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

2017-03-20 Thread Rob Willett
Just to close this thread down completely. We've implemented the changes on our production server and the actual performance increase is even better than we predicted. Our production server is a containerised Ubuntu Server. Its hardware configuration is significantly different to our Macs on

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

2017-03-20 Thread Rob Willett
David, We're English and masters of the understatement ;) Rob On 20 Mar 2017, at 15:04, David Raymond wrote: "... Our query has moved from 32 mins to 54 secs. We're quite happy with that performance increase." I have to admit that the hearty chuckle which that statement produced from me

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

2017-03-20 Thread David Raymond
"... Our query has moved from 32 mins to 54 secs. We're quite happy with that performance increase." I have to admit that the hearty chuckle which that statement produced from me hurt my sore throat. Totally worth it though. ___ sqlite-users mailing

Re: [sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Simon Slavin
On 20 Mar 2017, at 2:45pm, Simon Slavin wrote: > On 20 Mar 2017, at 2:42pm, Richard Hipp wrote: > >> More changes. Please Reload one more time. > > The changes are good but it’s still showing up as "alway" for me. I even > tried a different browser.

Re: [sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Richard Hipp
On 3/20/17, Simon Slavin wrote: > > On 20 Mar 2017, at 2:13pm, Richard Hipp wrote: > >> All other corrections implemented. > > Check "alway" on the current mask sentence again. No correction shown when > I retrieve the page. More changes. Please Reload

Re: [sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Simon Slavin
On 20 Mar 2017, at 2:42pm, Richard Hipp wrote: > More changes. Please Reload one more time. The changes are good but it’s still showing up as "alway" for me. I even tried a different browser. Simon. ___ sqlite-users mailing list

Re: [sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Simon Slavin
On 20 Mar 2017, at 2:13pm, Richard Hipp wrote: > All other corrections implemented. Check "alway" on the current mask sentence again. No correction shown when I retrieve the page. Simon. ___ sqlite-users mailing list

Re: [sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Richard Hipp
On 3/20/17, Simon Slavin wrote: > > " • (Not yet implemented) Create indexes that might have been helpful to > recent queries." > > —> If I recall a previous conversation correctly, it might clarify things to > make this sentence end "queries executed by this

Re: [sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Simon Slavin
On 20 Mar 2017, at 1:06pm, Richard Hipp wrote: > https://www.sqlite.org/draft/index.html In " • (Not yet implemented) Create indexes that might have been helpful to recent queries." —> If I recall a

[sqlite] First beta for SQLite 3.18.0.

2017-03-20 Thread Richard Hipp
The SQLite 3.18.0 release is forecast to occur within about two weeks. A snapshot of the latest amalgamation source code is available at https://www.sqlite.org/download.html Please review the changes and try out the latest code. Report any issues or concerns on this mailing list, or