Here I attached one more application this application is showing different
bitmap addresses but its not showing images in emulator.I wrote code for
retrieving images from sqlite but its showing error.this code is showing
text message. I want displaying images in emulator. if u know please send me
Hi Simon,
Here i attached my application.check once.
http://old.nabble.com/file/p32500286/databaseex.rar databaseex.rar
This application retrieving only one image.now i want retrieving list of
images like this.
--
View this message in context:
http://old.nabble.com/How-to-store-and-retrieve-li
Dezign is a nice cost effective tool, I used it in the past.
google wwwsqldesigner it is free, a little odd, but free is good.
On Mon, Sep 19, 2011 at 6:49 PM, Kai Peters wrote:
>
> Dezign for databases lets you do that:
>
> http://www.datanamic.com/dezign/supporteddatabases.html
>
>
> Cheers,
Dezign for databases lets you do that:
http://www.datanamic.com/dezign/supporteddatabases.html
Cheers,
Kai
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, Sep 19, 2011 at 5:25 AM, Simon Slavin wrote:
>
> On 18 Sep 2011, at 9:34pm, Anonymous wrote:
>
> > Hi can someone please explain how to build this from source? I wasn't
> able
> > to find it in the current amalgamation. Thanks.
>
> The amalgamation is just source code for use in your own
On 19 September 2011 19:25, Simon Slavin wrote:
>
> On 19 Sep 2011, at 7:13pm, Jaco Breitenbach wrote:
>
> > While on the topic of performance, I've performed a test in which new
> tables
> > were created within an active transaction (manual 'partitioning') and
> > populated within the same trans
SQLite version 3.7.8 is now available on the SQLite website
http://www.sqlite.org/
This is a maintenance release. Upgrading is optional. Details can be found
at
http://www.sqlite.org/releaselog/3_7_8.html
http://www.sqlite.org/news.html
Please report any problems you find to the S
On 9/19/2011 1:24 PM, Petite Abeille wrote:
On Sep 19, 2011, at 7:02 PM, George Brink wrote:
You can use PowerDesigner
Trivia #1: PowerDesigner download weights 390 MB. This compares to 1.4 MB for
SQLite. By weight, PowerDesigner does not provide 390 times the value of SQLite.
Trivia #2: A
On 19 Sep 2011, at 7:13pm, Jaco Breitenbach wrote:
> While on the topic of performance, I've performed a test in which new tables
> were created within an active transaction (manual 'partitioning') and
> populated within the same transaction. What I've found, was that as the
> number of tables c
Hi Christian,
Thanks for your response.
On 19 September 2011 16:45, Christian Smith wrote:
> On Mon, Sep 19, 2011 at 02:42:42PM +0100, Jaco Breitenbach wrote:
> > Hi Simon,
> >
> > Thanks for the reply.
> >
> > On 19 September 2011 13:23, Simon Slavin wrote:
> >
> > > > I run the database (3.7
On Sep 19, 2011, at 7:02 PM, George Brink wrote:
> You can use PowerDesigner
Trivia #1: PowerDesigner download weights 390 MB. This compares to 1.4 MB for
SQLite. By weight, PowerDesigner does not provide 390 times the value of SQLite.
Trivia #2: Any tool with "power" and/or "smart" in their n
On 9/19/2011 1:13 AM, Madhan Kumar wrote:
I want to design the table structure and create scripts with a
database designer
Do we have any tool(Free or cost) for Sqlite to design the tables, similar
like powerdesigner.
You can use PowerDesigner, just select 'ANSI Level 2' for DBMS.
On Sep 19, 2011, at 7:13 AM, Madhan Kumar wrote:
> I want to design the table structure and create scripts with a
> database designer
> Do we have any tool(Free or cost) for Sqlite to design the tables, similar
> like powerdesigner.
No, but may I suggest, as an alternative, a very powe
On Mon, Sep 19, 2011 at 02:42:42PM +0100, Jaco Breitenbach wrote:
> Hi Simon,
>
> Thanks for the reply.
>
> On 19 September 2011 13:23, Simon Slavin wrote:
>
> > > I run the database (3.7.7.1) in WAL mode, with checkpointing performed at
> > 10
> > > minute intervals.
> >
> > You turned 'PRAGMA
On Thu, Sep 15, 2011 at 05:47:47AM +, Grice, Lynton (L) wrote:
> Hi Ross,
>
> Many thanks for your response, I really appreciate it and will definitely
> drop you a quick email if I have any issues with the build.
>
> I am going to install GCC onto the AIX 5.3 box and will give it a try. I h
On 19 Sep 2011, at 3:16pm, Jaco Breitenbach wrote:
> I have to apologize: I had the PRAGMA options confused. My application
> makes exclusive use of PRAGMA journal_mode=WAL.
>
> What I meant to say was that the WAL log file is never truncated, except for
> it being removed when the database co
On Mon, Sep 19, 2011 at 1:52 PM, Simon Slavin wrote:
> However, I was testing on one particular setup only and didn't spend any
> time investigating the reasons for the timing I saw.
>
And i didn't consider the effects of different storage types, so we were
both half right ;).
--
- stephan
I have to apologize: I had the PRAGMA options confused. My application
makes exclusive use of PRAGMA journal_mode=WAL.
What I meant to say was that the WAL log file is never truncated, except for
it being removed when the database connection is closed successfully.
On 19 September 2011 15:02, S
On 19 Sep 2011, at 2:42pm, Jaco Breitenbach wrote:
> On 19 September 2011 13:23, Simon Slavin wrote:
>
>> If you're actually concerned about filesize, then WAL mode is probably not
>> the right mode to use. You may be better off with 'PRAGMA journal_mode =
>> DELETE'. If your platform stores
Hi Simon,
Thanks for the reply.
On 19 September 2011 13:23, Simon Slavin wrote:
> On 19 Sep 2011, at 10:13am, Jaco Breitenbach wrote:
>
> > CREATE TABLE T ( K varchar(22) PRIMARY KEY );
>
> Note that SQLite doesn't really do 'varchar'. All text fields are text
> fields and can have an
On 18 Sep 2011, at 9:34pm, Anonymous wrote:
> Hi can someone please explain how to build this from source? I wasn't able
> to find it in the current amalgamation. Thanks.
The amalgamation is just source code for use in your own projects. You can
find precompiled versions for linux, Mac and Win
On 19 Sep 2011, at 10:13am, Jaco Breitenbach wrote:
> CREATE TABLE T ( K varchar(22) PRIMARY KEY );
Note that SQLite doesn't really do 'varchar'. All text fields are text fields
and can have any number of characters in. You can choose to put 22 character
in each entry, but you might
Hi can someone please explain how to build this from source? I wasn't able
to find it in the current amalgamation. Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 19 Sep 2011, at 12:46pm, Mayuri wrote:
> I want to make application that fetch Images and profile
> of the person from the DataBaseand not from the XML...I know thats a
> difficult task
You have two obvious options:
Store your image in an image file, and store the path to that file a
On 19 Sep 2011, at 12:43pm, Stephan Beal wrote:
> On Mon, Sep 19, 2011 at 1:41 PM, Simon Slavin wrote:
>
>> It may or may not speed things up if you do a VACUUM between the DROP and
>> CREATE. It should make the file size smaller.
>
> OTOH, not vacuuming leaves the blocks in place for recycli
See this image link I want to make application that fetch Images and profile
of the person from the DataBaseand not from the XML...I know thats a
difficult task
https://market.android.com/publish/images/PQAAABUpX68z-Ts6OIXNuJrDtrFtAlLfUiZSFU-y_XHViD6X96UNtB7IkJF26L-WnrTAhckA9qdfcHVjLPJ2S
On Mon, Sep 19, 2011 at 1:41 PM, Simon Slavin wrote:
> It may or may not speed things up if you do a VACUUM between the DROP and
> CREATE. It should make the file size smaller.
>
OTOH, not vacuuming leaves the blocks in place for recycling, which "should"
be faster for subsequent insertions.
-
On 19 Sep 2011, at 11:07am, Sreekumar TP wrote:
> Which would be the quick way to clear all records in a table ( assumming
> 100,000 records) ?
>
> 1. Delete * from table_name
> 2. DROP TABLE table_name followed by CREATE TABLE
Faster to DROP and CREATE.
Note that you will have to CREATE your
We don't know how to help you. There are many ways to store images in a SQLite
database. You write software to put them in and more software to retrieve
them. Whatever problem you have doesn't seem to be related to SQLite. And you
say
> I am trying to store list of images in sqlite it's don
See the end of this page: http://sqlite.org/lang_delete.html#truncateopt
On Mon, Sep 19, 2011 at 1:07 PM, Sreekumar TP wrote:
> Hi,
>
> Which would be the quick way to clear all records in a table ( assumming
> 100,000 records) ?
>
> 1. Delete * from table_name
> 2. DROP TABLE table_name followe
On Mon, Sep 19, 2011 at 12:07 PM, Sreekumar TP wrote:
> Which would be the quick way to clear all records in a table ( assumming
> 100,000 records) ?
>
> 1. Delete * from table_name
> 2. DROP TABLE table_name followed by CREATE TABLE
>
According to this page:
http://orafaq.com/faq/difference_be
Hi,
Which would be the quick way to clear all records in a table ( assumming
100,000 records) ?
1. Delete * from table_name
2. DROP TABLE table_name followed by CREATE TABLE
-Sreekumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
On Mon, Sep 19, 2011 at 11:13 AM, Jaco Breitenbach
wrote:
> In the case of the data file, since my record is only 22 bytes wide, am I
> correct in assuming that the extra 48 bytes are for the index?
>
Don't forget that the on-storage data structures require their own
information, e.g. links betwe
Dear experts,
I am creating a (simple) model of the disc and I/O usage of my SQLite
database so I can advise my customers on hardware requirements.
My database schema is very simple. It contains only one table with a single
column with a primary key:
CREATE TABLE T ( K varchar(22) PRIMAR
WOW even I am looking for it ...i you get help just inform me to plz
Mayuri wrote:
>
> Hi All,
> I did one application store and retrieve only one image from sqlite,now
> I am trying to store list of images in sqlite it's done but I unable to
> retrieve those images on emulator.
>
35 matches
Mail list logo
