Re: [sqlite] Is there a way to return the row number? (NOTthe rowid)

At 05:49 04/07/2013, you wrote: ´¯¯¯ But in the bigger context of this discussion, I think SQLite might consider a row_number() function, or (my personal preference) some type of virtual column, such as "_row_number_". I suggest that term, since that's what Oracle, MS SQL Server, and

Re: [sqlite] Is there a way to return the row number? (NOTthe rowid)

On Tue, Jul 02, 2013 at 11:40:34AM +0100, Alex Bowden scratched on the wall: > > The SQL standard has always been a moving feast, chasing the field > implementations, perfectly capable of going back on it's earlier > mistakes, the main purpose of which, on a good day, is to promote >

Re: [sqlite] DLL Size differences and other info requested

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/07/13 16:38, Stephen Chrzanowski wrote: > I just reduced my built file size to BELOW what comes "out of the box" > from sqlite.org. I've turned off all optimizations and ran a full > build. I'm now sitting at the 599k mark. You probably want

Re: [sqlite] Different User different data

Haven't been called "Simon" often in my life, I guess there's a first for everything! :) Strange. I get it all the time. Well, now I know how it feels too! There are two problems, and they come up repeatedly on this and other lists: (1) the 'default' folder for a Windows app changes

Re: [sqlite] DLL Size differences and other info requested

You can also consider using -lstdc++_s (dynamic linkage for libstdc++) and -Os (optimize size) options to reduce the execuatble size in MinGW. I've never used VC++ (mostly using Linux and MinDW in Win32) but as far as I know, VC++ is capable of producing much more smaller executable. As

Re: [sqlite] DLL Size differences and other info requested

I just reduced my built file size to BELOW what comes "out of the box" from sqlite.org. I've turned off all optimizations and ran a full build. I'm now sitting at the 599k mark. So, the next process I'm going to have to come up with some testing to validate whether optimizations should be

Re: [sqlite] Different User different data

On 3 Jul 2013, at 11:50pm, RSmith wrote: > Haven't been called "Simon" often in my life, I guess there's a first for > everything! :) Strange. I get it all the time. > You have solved it halfway, but the Services have the exact same restrictions > as software in terms

Re: [sqlite] DLL Size differences and other info requested

Step in the right direction. Went from 850 to 788 with just that simple switch. I'll read up on what that compiler option does. On Wed, Jul 3, 2013 at 7:08 PM, Fehmi Noyan ISI wrote: > As far as I remember, DevC++ does not have "strip" option enabled by > default for

Re: [sqlite] DLL Size differences and other info requested

As far as I remember, DevC++ does not have "strip" option enabled by default for "release" version of your binary. You may want to have a quick look at your project compile options to minimize your binary size. The "-s" option reduces binary size significantly in some cases.

Re: [sqlite] DLL Size differences and other info requested

That link certainly helps. I'll poke at 'em. On Wed, Jul 3, 2013 at 6:53 PM, RSmith wrote: > Simply manipulating the compile-time options will create widely differing > sizes. You can exclude older support items etc. > A good overview of the compile-time options are given

Re: [sqlite] DLL Size differences and other info requested

Simply manipulating the compile-time options will create widely differing sizes. You can exclude older support items etc. A good overview of the compile-time options are given on the SQLite site. (Ok I'll stop being lazy and find you the actual link) http://www.sqlite.org/compile.html There,

Re: [sqlite] Different User different data

Haven't been called "Simon" often in my life, I guess there's a first for everything! :) You have solved it halfway, but the Services have the exact same restrictions as software in terms of what they are allowed to manipulate (well, not exactly the same, but close enough to make no difference

Re: [sqlite] DLL Size differences and other info requested

Hi Stephen, I don't know what compiler is used to build the official SqLite dll, but provided it is some version of Vc++ my experience is that MinGw often produces larger and sometimes significantly slower binaries on Windows than VC++ does. In an unrelated project of mine, the binary size

[sqlite] DLL Size differences and other info requested

Just for kicks because I wanted to learn "how it was done", I decided to download the amalgamation code and compile to a Win32 DLL. The secondary purpose of my doing so was that I also wanted to write a 3rd party app that'd export all headers of the amalgamation to a different format that I can

Re: [sqlite] Different User different data

On 3 Jul 2013, at 11:19pm, Steffen Mangold wrote: > But my Windows Service (under LOCAL SERICE right) still see other data. :( > I don't know how to fix this. Sorry, nor do I. I don’t use Windows. Simon. ___

Re: [sqlite] Different User different data

Hi Simon, Thanks for you quick response! I found the same reson. I now move my DB from "c:\program files\..." to "e:\..." (this is a separate data partition). The effect is now that with my DB tool (with and without admin right) I see the same data. Fine so long! :) But my Windows Service

Re: [sqlite] Different User different data

This has nothing to do with SQLite sadly, but still easy to fix. It's the WIndows UAC which is doing this to you, as it should for data that it tries to protect. I am guessing you have the DB in a protected location, such as somewhere within c:\Program Files\ or in c:\Windows\ or such... or in

Re: [sqlite] Different User different data

On 3 Jul 2013, at 10:41pm, Steffen Mangold wrote: > I have some strainge behavior with a SQLIte DB. > If I open the database with my DB tool with administrator right I see other > data as when I open the DB with my tool in non admin mode. You’re probably opening

[sqlite] Different User different data

Hi, I have some strainge behavior with a SQLIte DB. If I open the database with my DB tool with administrator right I see other data as when I open the DB with my tool in non admin mode. Is this normal? And if yes can I deactivate this? To be clear: I start my DB tool normal (local user

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

FYI: For a different approach, check out Zumero (http://zumero.com) which synchronizes SQLite changes within the db rather than the whole db as a file. Disclosure: I am a co-founder of Zumero, which is commercial, proprietary, non-open-source, etc. I mention this only because we often

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

On 6/27/2013 12:38 PM, joe.fis...@tanguaylab.com wrote: Anyone, Does anyone have good or bad experiences using a SQLite database in a shared folder? The 'Dropbox / Drive / SkyDrive / One' I use Dropbox for SQLite files a lot. If I am not careful to be making changes to a file on only

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

I have one application that deals with a few tens of megabytes of data. Dropbox tries to sync the file with an open-shared connection, and any changes seem to want to UL the whole file again, not to mention the hammering of the journal/wal file. So what I've done is open the file in exclusive

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

Keith, I find this a little arrogant. I could say exactly the opposite, not caring about efficiency is ... (introduce whatever words you like). Why is this ranking addressed here? http://www.schemamania.org/sql/#rank.rows Why do you need "order by" in sql but may not ask the ranking having a

Re: [sqlite] Differences from 3.7.11 to 3.7.16/17 ?

I should also mention that I have 16.2 compiled from the amalgamation, and I think today I'll be compiling whatever version is up on the site today. On Wed, Jul 3, 2013 at 8:49 AM, Stephen Chrzanowski wrote: > Although not from an official site, I have the DLL versions from

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

> Given all that, I will NEVER use the pure sql (if I can use any other > solution). given that the "ordinal in the result set" is a fallacious concept being created for the convenience of an application program which cannot deal with sets properly (or more likely a programmer who does not

Re: [sqlite] Differences from 3.7.11 to 3.7.16/17 ?

Although not from an official site, I have the DLL versions from the official site in my repo. I can put them up if you'd like on dropbox. - 3.04.02 - 3.06.23.1 - 3.07.09. - 3.07.14 - 3.07.14.1 - 3.07.15.1 On Fri, Jun 28, 2013 at 11:55 AM, Marten Feldtmann wrote: > Are

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

James, I reply from the web and I can't easily quote. I don't really want to argue whether it's a workaround or not. I understand perfectly that's valid standard sql. However please accept that the given sql is quite complex; you have to duplicate in the join clause the ordering... About