I'm assuming you care about rounding and precision because you are doing some
sort of financial application. In that case, you'd want to be doing decimal
floating point math. This library will probably do the job for you, but there
should be arbitrary precision libraries out there if not. . .
h
yED is nice, but there isn't an automated way of loading a schema into it to
get an ER diagram out, is there?
I thought if you go down that path you were basically stuck drawing your
diagram by hand (using their ER diagram shapes).
-sean
-Original Message-
From: sqlite-users-boun...@sql
I haven't tried any of the pro options since getting management to buy into
something free is easier than something that isn't.
I like navicat lite generally, though the lite version does not have
diagramming. Their commercial edition does have this and they have 30 day free
trials, so I'd prob
He wants an ER diagram, not a dump of the tables and contents. I wanted this
too and did some digging.
There are a lot of pay tools that can do this (I think navicat for example does
it). If pay tools are not an option, there are a bunch of things that claim to
work, such as SQLFairy and some v
one possibility: use || for concatenation.
e.g. "(" || select(..) ||"," select() ||")"
maybe there is a cleaner way in sqlite.
-sean
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Macgyver7
Sent: Friday, December 02, 2011
Haven't fought with times in sqlite myself, but if everything's being stored as
strings, I suspect what you need to do is use
something like:
strftime("%s",TIME(NOW)) > strftime("%s",FIELD1)
That is, convert the complex strings into something that sqlite can reasonably
treat as numbers for the
your problem is that v refers to data in the original row-- which v you see
when you group is totally arbitrary, and there's no requirement on sql to use
the same one for ordering. You need to specify an aggregate on the non-grouping
columns to really have any sort of defined behavior.
What I w
Behalf Of Jay A. Kreibich
Sent: Thursday, October 20, 2011 10:31 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] does a unique constraint imply an index
On Thu, Oct 20, 2011 at 09:02:55AM -0700, Sean Pieper scratched on the wall:
> I apologize for the newbie question, but the an
I apologize for the newbie question, but the answer isn't obvious from looking
through the site.
In postgres, I know that if I declare a column or set of columns to have a
unique constraint, there is also an index created on those columns. Does the
same thing happen in sqlite, or does the optim
I have not used it, but kexi claims to offer many of the features of access:
http://www.kexi-project.org/screenshots.html
someone put together a really nice wiki of various admin tools for sqlite here
with descriptions of features, licensing, and fees.
http://www.sqlite.org/cvstrac/wiki?p=Managem
the clarification :-).
-sean
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Richard Hipp
Sent: Wednesday, September 21, 2011 12:23 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] c-api document suggestion
On Wed,
There's an apparent inconsistency in the behavior of sqlite3_bind_text and
sqlite3_prepare_v2.
If the user supplies the length of the argument rather than using -1, bind_text
expects that this length exclude the null termination, whereas prepare
apparently expects it to include the null termina
12 matches
Mail list logo