Am 15.05.2011 16:04, schrieb Christoph P.U. Kukulies:
> I keep getting an SQL error
> "unable to open database file"
>
> after doing some 20 inserts into two tables of my database in a loop
> in a java function.
>
> In the main code I have
> String sql="INSERT INTO part(name,md5sum,size,pfad) VALUE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 08:49 PM, romtek wrote:
> I don't know about how things work in your world, but in mine requirements
> for apps change sometimes, so I have to enter design stage after an app (may
> be a website) has been released. Perhaps, you are a clai
It's perfectly fair to ask for a feature. And ALTER TABLE rename
column support is a well justified feature to want, IMO; I don't blame
you for wanting it. Whether it will be added, or when, I'd not know.
The dev team (whom I do not speak for) has its priorities, and its
paying customers to worry
On May 15, 2011, at 10:49 PM, romtek wrote:
> Let's not make this issue into something that it's
> not.
Let's not.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sun, May 15, 2011 at 10:00 PM, Roger Binns wrote:
> On 05/15/2011 07:48 PM, romtek wrote:
> > I was describing what I have to do during design time, which often
> happens
> > after a website has been launched and is operational.
>
> Huh? You launch and have a site in production and then you d
On Sun, May 15, 2011 at 10:05 PM, Nico Williams wrote:
> Right, well, SQLite3 doesn't support renaming columns. Internally
> SQLite3 only stores the CREATE statements for all schema elements
> (plus actual b-trees for tables and indexes). Specifically SQLite3
> does not store schema elements in
On Sun, May 15, 2011 at 5:22 PM, Simon Slavin wrote:
> Yeah, you have to fake it by making a new table. You want support for more
> ALTER TABLE variants. The proper way to do it would be to
>
> ALTER TABLE myTable ADD COLUMN dateAdded
> UPDATE myTable SET dateAdded = date
> ALTER TABLE myTable
On Sun, May 15, 2011 at 9:44 PM, romtek wrote:
> On Sun, May 15, 2011 at 5:10 PM, Mr. Puneet Kishor wrote:
>> > I want to rename date to dateAdded.
>>
>> sqlite doesn't support changing the name of a table column (and, neither
>> you nor your user should be doing this -- there is something strange
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 07:48 PM, romtek wrote:
> I was describing what I have to do during design time, which often happens
> after a website has been launched and is operational.
Huh? You launch and have a site in production and then you design it?
> I som
On May 15, 2011, at 9:44 PM, romtek wrote:
> An analogy: if
> I want to create a letter with pretty styles and maybe images, I will use MS
> Word or, at least, Open Office. I will not write a program to do that :)
Wrong analogy above. The correct analogy would be, if you had to modify MS Word
On Sun, May 15, 2011 at 5:27 PM, Roger Binns wrote:
> Wanting to rename a column should be a rare thing since it is so rare. If
> you are frequently renaming columns then your code will be very brittle.
>
>
I was describing what I have to do during design time, which often happens
after a websit
On Sun, May 15, 2011 at 5:10 PM, Mr. Puneet Kishor wrote:
>
> > A table:
> >
> > id, eventName, date
> >
> > I want to rename date to dateAdded.
> >
>
>
> sqlite doesn't support changing the name of a table column (and, neither
> you nor your user should be doing this -- there is something strange
Mr. Puneet Kishor wrote:
> I am trying to get time stamps to be reported as '10:33 AM' and '1:27 PM'
> instead of '10:33' or '13:27'. I don't see any
> formatting options to return the time in 12-hour format with AM/PM suffixed.
> Am I missing something, or do I have to roll my own?
You are no
> But apparently your "not 100% sure" is actually "it's not
> true" in this case (as your tests showed).
No, I think we're good. As long as one is very careful (as Roger mentioned),
it seems to work fine under GCD. I was kinda reaching, thinking that moving
across threads mattered.
I was being
> I'm still not 100% sure if there's a problem sharing connections across
> threads with SQLITE_OPEN_NOMUTEX as long as I guarantee that they aren't
> concurrent. I suspect there aren't, but I'm not 100% sure. Any case where
> sqlite3 would be less than happy that pthread_self wasn't always the
On Sun, May 15, 2011 at 10:39:22PM +0100, Simon Slavin scratched on the wall:
>
> On 15 May 2011, at 10:33pm, romtek wrote:
> > So, I am asking developers of SQLite to make it easy for tool developers to
> > offer the ability to rename attributes.
>
> The SQL specification does not use the term '
on 5/14/11 9:02 AM Trevor Borgmeier wrote:
> ...I was surprised when I tried a similar query with the same data in MySQL
> and saw that it worked -- MySQL parsed the fields contents as if they were
> separate items.
I just wanted to correct my statement about my MySQL query -- I wasn't
using IN,
I am trying to get time stamps to be reported as '10:33 AM' and '1:27 PM'
instead of '10:33' or '13:27'. I don't see any formatting options to return the
time in 12-hour format with AM/PM suffixed. Am I missing something, or do I
have to roll my own?
Puneet.
Has anyone implemented the search result ranking function in Perl?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Am Sun, 15 May 2011 17:10:53 -0500 schrieb Mr. Puneet Kishor:
> sqlite doesn't support changing the name of a table column (and, neither you
> nor
> your user should be doing this -- there is something strange with your app
>requirements). That said, you can "rename" a column by creating a new ta
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 03:05 PM, romtek wrote:
> I want to rename date to dateAdded.
>
> People currently jump through hoops in order to achieve such a simple (from
> the user's point of view) and needed goal:
> http://stackoverflow.com/questions/805363/how-do
On 15 May 2011, at 11:05pm, romtek wrote:
> I will give you an example, and you correct my use of the terms, please.
>
> A table:
>
> id, eventName, date
>
> I want to rename date to dateAdded.
Okay, that's a column name, and you want the ability to rename columns.
> People currently jump th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 11:14 AM, Steven Parkes wrote:
>> Isn't that exactly what NOMUTEX does?
>
> The docs (http://www.sqlite.org/threadsafe.html) say
>
> The SQLITE_OPEN_NOMUTEX flag causes the database connection to be in the
> multi-thread mode and
>
On May 15, 2011, at 5:05 PM, romtek wrote:
> On Sun, May 15, 2011 at 4:39 PM, Simon Slavin wrote:
>
>>
>> On 15 May 2011, at 10:33pm, romtek wrote:
>>
>>> So, I am asking developers of SQLite to make it easy for tool developers
>> to
>>> offer the ability to rename attributes.
>>
>> The SQL
On Sun, May 15, 2011 at 4:39 PM, Simon Slavin wrote:
>
> On 15 May 2011, at 10:33pm, romtek wrote:
>
> > So, I am asking developers of SQLite to make it easy for tool developers
> to
> > offer the ability to rename attributes.
>
> The SQL specification does not use the term 'attribute' in any way
On 15 May 2011, at 10:33pm, romtek wrote:
> So, I am asking developers of SQLite to make it easy for tool developers to
> offer the ability to rename attributes.
The SQL specification does not use the term 'attribute' in any way that would
give them names. Can you explain what you mean by 'ren
Hi,
SQLite probably was intended as an embedded database for standalone
software. However, because of its promotion by PHP community, it's been used
to power websites. I use it for that purpose too and prefer it over other
SQL DB solutions (primary because it allows me to move/backup data from a
s
Ah, crud. I kinda forgot I had a WAL checkpoint thread running. I thought I had
disabled that a long time ago. And it was sharing a connection on a different
thread.
Fixing that, things seem stable under GCD with SQLITE_OPEN_NOMUTEX.
I'm still not 100% sure if there's a problem sharing connecti
Am 15.05.2011 20:43, schrieb Amy and Steve:
> Thanks! I will study the sqlite3_auto_extension closer. I had trouble
> compiling the extc file, but I can't remember what the errors were
> and I just got back in town, so I will have to work my back to trying to
> compile it.
I remember I had a
Thanks! I will study the sqlite3_auto_extension closer. I had trouble
compiling the extc file, but I can't remember what the errors were
and I just got back in town, so I will have to work my back to trying to
compile it.
Steve.
On 05/10/2011 01:24 PM, Mays, Steve wrote:
>> Question 1.)
Hello,
a friend of mine needs to read from an SQLite database that I made. He
needs to do it in Java, and what's special about the database is that it
contains some indexes which are based on a custom collation (German
umlaut).
Does anyone know of a recommendable java library (JDBC or else) that
> Isn't that exactly what NOMUTEX does?
The docs (http://www.sqlite.org/threadsafe.html) say
The SQLITE_OPEN_NOMUTEX flag causes the database connection to be in the
multi-thread mode and
the SQLITE_OPEN_FULLMUTEX flag causes the connection to be in serialized mode.
Is this wrong?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 10:45 AM, Steven Parkes wrote:
> Not trying to throw them away ...
Isn't that exactly what NOMUTEX does?
> trying to switch from Serialized to Multi-thread. My reading of the docs
says that that's what SQLITE_OPEN_NOMUTEX does. Did I mi
>> I've been using sqlite3 under iOS fine in FULLMUTEX mode, but it dies
>> horribly with NOMUTEX
>
> What problem are you trying to solve by getting rid of SQLite's mutexes?
> Even if you remove them you still have to add the same thing back in again
> to ensure you don't use SQLite internals c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 09:37 AM, Steven Parkes wrote:
> I've been using sqlite3 under iOS fine in FULLMUTEX mode, but it dies
> horribly with NOMUTEX
What problem are you trying to solve by getting rid of SQLite's mutexes?
Even if you remove them you still h
There a BUNCH of SQLite objects shown when I look through the object browser.
I was hoping to find samples for using those.
But I can figure out how to use the code from the link.
Don Ireland
-Original Message-
From: Simon Slavin
To: General Discussion of SQLite Database
Sent: Sun, 1
This is a little out there but I've been thinking about it and wondered if
anyone had any comments:
I've been using sqlite3 under iOS fine in FULLMUTEX mode, but it dies horribly
with NOMUTEX and I'm pretty sure this is because of my use of Grand Central
Dispatch (GCD).
GCD is related to threa
On 15 May 2011, at 3:58pm, Don Ireland wrote:
> I never said I need C++ not C. I asked for sample code for use in C++. If C
> code will work just fine then sample C code would be fine and dandy with me.
See the end of
http://www.sqlite.org/quickstart.html
after that, Google on 'sqlite c sampl
I never said I need C++ not C. I asked for sample code for use in C++. If C
code will work just fine then sample C code would be fine and dandy with me.
I've already been reading through the docs you pointed me to. But it's kinda
hard to wrap my head around--they even start out warning that it'
Not off topic, but i'm confused about why you explicitly need C++ for that."
I never said I need C++ not C. I asked for sample code for use in C++. If C
code will work just fine then sample C code would be fine and dandy with me.
Don Ireland
-Original Message-
From: Stephan Beal
To: G
I keep getting an SQL error
"unable to open database file"
after doing some 20 inserts into two tables of my database in a loop
in a java function.
In the main code I have
String sql="INSERT INTO part(name,md5sum,size,pfad) VALUES (?,?,?,?)";
String sql1="INSERT INTO
candidate(md5sum,basename,pr
Pontiac wrote:
> On 05/13/2011 03:15 PM, Trevor Borgmeier wrote:
>> SELECT categories FROM myTable WHERE (","||categories||",") LIKE "%,7,%";
>
> Careful with how you have your like. As an added bonus, if you were to
> hunt for category 1, your statement would be LIKE "%,1,%" which would
> retur
I wrote one wrapper, that can be compiled, like sqlite3, in your C++
program.
It doesn't rely on any third library except sqlite3.
The update of sqlite3 is just done by replacing the amalgamation files.
https://gitorious.org/sylisa-dblite/sylisa-dblite
It uses the syntax borrowed from soci++, ver
On 05/13/2011 03:15 PM, Trevor Borgmeier wrote:
> I have a database where a field's value is a comma separated list
> indicating the basic categories the item belongs to.
>
> so if the "categories" field has a value of "1,8,15"
>
> I want to do a query like this:
>
> SELECT categories FROM myTable
On Sun, May 15, 2011 at 11:39 AM, Don Ireland wrote:
> Thanks for taking the time to respond. But I'd prefer to learn to use
> SQLite.
Then use sqlite's API. Why require C++? sqlite's API can be used just fine
from C++ programs.
> If I use one of these wrappers, I have to depend on someone
The official programming API is in C and Tcl.
If you want C++ API, you need to use 3rd party wrappers or write your own.
To use C API, go to "SQLite Programming Interfaces" section at
http://sqlite.org/docs.html
On May 15, 2011 5:39 PM, "Don Ireland" wrote:
>
> Thanks for taking the time to resp
Hi
Any idea how to install System.Designer.dll file? I tried installing it as per
the below link with below xml file as extension xml file.
I created a custom extensions folder under C:\Program Files (x86)\Microsoft
Visual Studio 10.0\VSTSDB\Extensions and copied the System.Designer.dll file
Thanks for taking the time to respond. But I'd prefer to learn to use SQLite.
If I use one of these wrappers, I have to depend on someone to maintain it
anytime SQLite is updated. And from what I can tell, the last update to the
wrapper code was I n 2007.
Just as an example, I'm currently lo
Just a correction... I am using Linq to SQL classes, not EDMX files. So I
can only create a db connection in server explorer, will I able to drop the
tables from there to linq to sql classes designer.
Thanks.
-Original Message-
From: Suresh Kumar R
Sent: Sunday, May 15, 2011 1:23 PM
To:
On Sun, May 15, 2011 at 4:24 AM, Don Ireland wrote:
> Can anyone suggest a good source for sample C++ code? I really would
> rather not come here and ask for every little thing--I'd learn it better
> this way.
>
There are 3 different C++ wrappers here:
http://fossil.wanderinghorse.net/repos/sq
Hi
Any idea how to install System.Designer.dll file? I tried installing it as per
the below link with below xml file as extension xml file.
I created a custom extensions folder under C:\Program Files (x86)\Microsoft
Visual Studio 10.0\VSTSDB\Extensions and copied the System.Designer.dll file
the
51 matches
Mail list logo