Re: [sqlite] Defining a table that starts rowid as 0

On 24/07/2009 3:10 PM, Simon Slavin wrote: > On 24 Jul 2009, at 5:49am, John Machin wrote: > >> On 24/07/2009 3:22 AM, Simon Slavin wrote: >> >>> And note that if you have a column which is an integer that >>> has doesn't allow duplicates, SQLite will automatically use that >>> column as the one

Re: [sqlite] Defining a table that starts rowid as 0

On 24 Jul 2009, at 5:49am, John Machin wrote: > On 24/07/2009 3:22 AM, Simon Slavin wrote: > >> And note that if you have a column which is an integer that >> has doesn't allow duplicates, SQLite will automatically use that >> column as the one it uses for _rowid_, etc.. So define your own >>

Re: [sqlite] Defining a table that starts rowid as 0

On 24/07/2009 3:22 AM, Simon Slavin wrote: > And note that if you have a column which is an integer that > has doesn't allow duplicates, SQLite will automatically use that > column as the one it uses for _rowid_, etc.. So define your own > integer column, feed it whatever integers you

[sqlite] SQLite OLEDB provider for Linked Server

We would like to setup a linked server from SQL2000, SQL2005, and SQL2008 systems to connect and query a SQLite db. Has anyone ever accomplished this?? How would we query a SQLite db from SQL server?? We have tried to use the Cherry City Software OLEDB provider but it won't let us activate

Re: [sqlite] Installing SQLite

On Thu, Jul 23, 2009 at 9:03 PM, Rich Shepard wrote: >   Er, Dan, ... without the build step there's nothing to install. A well-formed Makefile should specify the default build target as a dependency of the install target. Hamish

Re: [sqlite] Installing SQLite

On Fri, 24 Jul 2009, Dan wrote: > There is an amalgamation package that includes a supported configure > script. "./configure && make install" and you're away. Er, Dan, ... without the build step there's nothing to install. The usual sequence is ./configure && make && make install. Or, you

Re: [sqlite] Installing SQLite

That might be an option to consider. But, I think there might be a rather small number of potential SQLite users interested. I would think the group with the greatest benefit of that kind of package would be students and serious rookies. Most users I feel either pre possess the required

Re: [sqlite] Installing SQLite

On Jul 23, 2009, at 10:50 PM, Jay A. Kreibich wrote: > On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on > the wall: > >> I think the OP just has the wrong expectations. > > Yes, and no. While SQLite doesn't have a one-click-to-install > download, I have to agree that the

Re: [sqlite] Installing SQLite

If there was a zip file that included an open source compiler and linker and a well commented makefile along with SQLite's source code so that anyone (at least under Windows) can generate the version SQLite dll and command shell that they want without having to search for tools, I think more

Re: [sqlite] Defining a table that starts rowid as 0

On Thu, Jul 23, 2009 at 12:39 PM, Shaun Seckman (Firaxis) wrote: > I currently have all my tables with a column called "ID" that is defined > as Integer Primary Key. For legacy code purposes, I need ID to start at > 0 and not at 1 however I'd like to have this be defined

Re: [sqlite] Defining a table that starts rowid as 0

I currently have all my tables with a column called "ID" that is defined as Integer Primary Key. For legacy code purposes, I need ID to start at 0 and not at 1 however I'd like to have this be defined as part of the table schema and not as part of the insertion statement. I tried defining it as

Re: [sqlite] Defining a table that starts rowid as 0

On Thu, Jul 23, 2009 at 06:22:53PM +0100, Simon Slavin scratched on the wall: > > On 23 Jul 2009, at 4:56pm, Rich Shepard wrote: > > > Using rowid for anything is not a good idea. There's no guarantee > > that the > > column values associated with each rowid are static. It's much > >

Re: [sqlite] Defining a table that starts rowid as 0

On 23 Jul 2009, at 4:56pm, Rich Shepard wrote: > Using rowid for anything is not a good idea. There's no guarantee > that the > column values associated with each rowid are static. It's much > better to > ignore the rowid and use either a natural primary key or a defined > one. Agreed.

Re: [sqlite] Installing SQLite

Jay, your email below is superb. It's dispassionate, accurate, diplomatic, and informative. I was also disappointed to see this email list go the way of so many others over the past day or so, but it's easy enough to fix it. Stop calling someone else a doofus for selecting a particular OS to

Re: [sqlite] sqlite_mem_methods

On Jul 23, 2009, at 11:16 PM, Zachary Turner wrote: > I was looking into overriding the sqlite_mem_methods interface to > specify my own allocator. The two functions I have a question about > are these: > > int (*xSize)(void*) > int (*xRoundup)(int size); > > I've briefly looked over the source

[sqlite] sqlite_mem_methods

I was looking into overriding the sqlite_mem_methods interface to specify my own allocator. The two functions I have a question about are these: int (*xSize)(void*) int (*xRoundup)(int size); I've briefly looked over the source code it *seems* like I can safely return 0 from xSize and 'size'

Re: [sqlite] Installing SQLite

Grrr I didn't meant to send this just yet. But since I did, I guess I need to finish it. On Thu, Jul 23, 2009 at 10:50:37AM -0500, Jay A. Kreibich scratched on the wall: > On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the wall: > > > I think the OP just has the

Re: [sqlite] Defining a table that starts rowid as 0

On Thu, 23 Jul 2009, Shaun Seckman (Firaxis) wrote: >Is it possible in the create a table where the rowid > will start at 0 instead of 1 prior to inserting a row and explicitly > stating that the rowid is 0? Shaun, Using rowid for anything is not a good idea. There's no

Re: [sqlite] Installing SQLite

On Thu, Jul 23, 2009 at 09:46:24AM -0400, Wilson, Ron P scratched on the wall: > I think the OP just has the wrong expectations. Yes, and no. While SQLite doesn't have a one-click-to-install download, I have to agree that the current build and distribution state of SQLite is... let's just

Re: [sqlite] Installing SQLite

I think you guys are most likely feeding a Troll, or the original poster might ought to contact his IS support department, or enroll in some introductory basic home computer continuing education courses in his local area. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Defining a table that starts rowid as 0

Shaun Seckman (Firaxis) wrote: >Is it possible in the create a table where the rowid > will start at 0 instead of 1 prior to inserting a row and explicitly > stating that the rowid is 0? You can specify rowid explicitly in an insert statement: insert

[sqlite] Defining a table that starts rowid as 0

Hello, Is it possible in the create a table where the rowid will start at 0 instead of 1 prior to inserting a row and explicitly stating that the rowid is 0? -Shaun ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Installing SQLite

On 23/07/2009 6:48 AM, Rich Shepard wrote: > On Wed, 22 Jul 2009, scabral wrote: > >> When i download the sqlite-amalgamation-3_6_16.zip i get 3 text files: >> >> sqlite3 C File >> sqlite3 H File >> sqlite3ext H File > >> what am i supposed to do with those? > > Well, based on what others

Re: [sqlite] Extending the db file [was: Memory leak on inserting fromsqlite c/c++ interfaces]

Zachary Turner wrote: > Speaking of extending the file, if I know in advance that my database > is ultimately going to end up being very large, is there any way for > me to extend the file up front? Or to specify the increment in which > sqlite will extend the file when

[sqlite] Extending the db file [was: Memory leak on inserting from sqlite c/c++ interfaces]

On Wed, Jul 22, 2009 at 3:22 PM, Igor Tandetnik wrote: > Zachary Turner > wrote: >> I still don't understand the transactions.  For example, I issue a >> single BEGIN at the start of my application and then insert about >> 500MB of data through many

Re: [sqlite] Installing SQLite

> Well, based on what others wrote about your initial comments, I suggest > that you replace XP with a linux distribution. Then you can compile that > source code all by yourself. On the other hand, if you insist on sticking > with Microsoft, download one of the pre-built Winduhs .zip files as I >

Re: [sqlite] Ability to convert Access to SQLite

Since this appears to be a reporting application with multiple readers, why not use an HTML report output and any web browser. Then if you decide to publish the reports on your network, there is little more needed to do so. On Wed, 2009-07-22 at 10:12 -0700, scabral wrote: > Do you know of any

Re: [sqlite] Installing SQLite

This is not a simple tool. I is primarily designed to be embedded in applications. Your opinion about the quality of the *install* instructions leads people to believe that you may need a better understanding of the skill level required to use Sqlite. On Wed, Jul 22, 2009 at 1:43 PM, scabral