Re: [sqlite] Easyer way ?

[Reid Thompson]

Puneet Kishor wrote:



You will need to type the values at least once to convert from paper 
to bits, but you need not type in the INSERT command. Type them in 
Excel, or in a text editor... save the file as a CSV file, then load 
the file in SQLite (I believe there is a command to load CSV... if 
not, use the editor's capability to add the INSERT INTO car bit with 
the correct parens and quotes, etc.).


Make sure to quote the text, and not the numbers. Make sure the values 
are in the same order as the columns, and you won't even have to name 
the columns.


Puneet Kishor

This is going to be your quickest way -- unless you have a VERY good OCR 
program that can give you a head start.

[sqlite] How to use PRAGMA SYNCRONOUS ??

[Zibetti Paolo]

Here are a couple of questions for the most expert SQLite users.

Question 1
Is #PRAGMA SYNCRONOUS a global database setting or is it possible to open
two handles on the same database and set two different values for #PRAGMA
SYNCRONOUS on the two handles ?

Question 2
Is it possible to change the value of #PRAGMA SYNCRONOUS on the same handle
during the execution of the program ? In other words can a do something like
this:

begin exclusive transaction
#PRAGMA SYNCRONOUS 2
  ... some very important update...
commit

... some code unrelated to DB...

begin exclusive transaction
#PRAGMA SYNCRONOUS 0
  ... less important update...
commit

... some code unrelated to DB...

begin exclusive transaction
#PRAGMA SYNCRONOUS 2
  ... some very important update ...
commit


Thank you , bye

Re: [sqlite] Easyer way ? (RE)

[René Tegel]

he's just joking ;)

have you looked here: http://sqlitebrowser.sourceforge.net/ ?

regards,

rene


Richard Nagle wrote:

Is this some kind of sick sql humor?

Did someone give this type of information,
to you, when you needed help?

Its great when you learn, and now you know,
but, its sad, when you know, and you don't let it go.

perhaps, there needs to be a newbie-novice email group
made for sqlite user, whom DON'T know, but want to know.

This way, we DON'T have to read JUNK MAIL.

Best Regards-
Richard

PS: Big Thanks, To all whom did help with this, on and off
the list


Doug Hanks wrote:


Just stick the papers in the CDROM and tye "sqlite-import"

Re: [sqlite] Easyer way ? (RE)

[Doug Hanks]

It's just a joke - no need to get excited.  It wasn't meant as condescending.

On 9/24/05, Richard Nagle <[EMAIL PROTECTED]> wrote:
> Is this some kind of sick sql humor?
>
> Did someone give this type of information,
> to you, when you needed help?
>
> Its great when you learn, and now you know,
> but, its sad, when you know, and you don't let it go.
>
> perhaps, there needs to be a newbie-novice email group
> made for sqlite user, whom DON'T know, but want to know.
>
> This way, we DON'T have to read JUNK MAIL.
>
> Best Regards-
> Richard
>
> PS: Big Thanks, To all whom did help with this, on and off
> the list
>
>
> Doug Hanks wrote:
> > Just stick the papers in the CDROM and tye "sqlite-import"
> >
>


--
- Doug Hanks = dhanks(at)gmail(dot)com

Re: [sqlite] Easyer way ? (RE)

[Richard Nagle]

Is this some kind of sick sql humor?

Did someone give this type of information,
to you, when you needed help?

Its great when you learn, and now you know,
but, its sad, when you know, and you don't let it go.

perhaps, there needs to be a newbie-novice email group
made for sqlite user, whom DON'T know, but want to know.

This way, we DON'T have to read JUNK MAIL.

Best Regards-
Richard

PS: Big Thanks, To all whom did help with this, on and off
the list


Doug Hanks wrote:

Just stick the papers in the CDROM and tye "sqlite-import"

Re: [sqlite] Easyer way ?

[Doug Hanks]

Just stick the papers in the CDROM and tye "sqlite-import"

On 9/24/05, Richard Nagle <[EMAIL PROTECTED]> wrote:
> Sorry, to say,
> its a STACK of papers on my desk, Next to the Other several stacks,
> of papers...
>
> So, Was looking for a easier Method of getting Paper (typing) data,
> into Sqlite, with out going threw all the insert...commands.
>
> Thanks -
> Richard
>
>
> Reid Thompson wrote:
> > Richard Nagle wrote:
> >
> >> is there a easier way of typing in data to Sqlite.
> >>
> >> sqlite> insert into car (md_num, md_name, style, year)
> >>...> values (1, 'Honda', 'Coupe', 1983)
> >>...> ;
> >>
> >> Man, just 806 more listing
> >> just looking for some short cuts, or helper apps...etc.
> >> to cut down some of the typing.
> >>
> >> Thanks -
> >> Richard
> >
> > do you already have the data in another format?
> > csv?, excel?, space delimited?
> > just about any consistent format can be handled via one of many of the
> > scripting languages.
> >
>


--
- Doug Hanks = dhanks(at)gmail(dot)com

Re: [sqlite] Easyer way ?

[Kurt Welgehausen]

I believe more than one subscriber to this list have written
utilities to manage SQLite databases. I've never used one, but
I expect they have GUIs that will allow you to enter and
insert data. A Google search will probably turn up something.

Regards

Re: [sqlite] Including sqlite3 in a GNU project

[Doug Hanks]

Mike,

This only tries to find existing installations of sqlite3.

I said I want to include a version of sqlite3 in my GNU project, have
GNU tools auto configure and compile it - then use libtool to link
against the static object.

Doug

On 9/24/05, Mike Chirico <[EMAIL PROTECTED]> wrote:
> On Thu, Sep 22, 2005 at 07:23:57AM -0700, Doug Hanks wrote:
> > Has anyone went through (what I feel is a painful process) of adding
> > sqlite in a GNU project?
>
> The following may help, which is a small package:
>http://ftp1.sourceforge.net/souptonuts/quota_examples.tar.gz
> or
>http://ftp1.sourceforge.net/cpearls/simple_but_common_cpp.tar.gz
>
> I put the following in my configure.in or configure.am file which
> checks for version 3 of sqlite.
>
>   AC_CHECK_LIB(sqlite3,sqlite3_open,[],found=no)
>
> This is the full configure.in file
>
>
> AC_INIT(getquota.c)
> AC_PROG_CXX
>
> if test -f VERSION; then
>   VERSION=`cat VERSION`
>   echo "Version set to $VERSION"
> else
>   VERSION='0.0.0'
> fi
> AM_INIT_AUTOMAKE(quota_examples, $VERSION )
> AC_PROG_CXX
> CXXFLAGS='-Wall -W -O2 -s -pipe'
> CFLAGS='-Wall -W -O2 -s -pipe'
>
>
> AM_CONDITIONAL(HAVE_SQLITE, true)
> AC_CHECK_LIB(sqlite3,sqlite3_open,[],found=no)
>  if test "$found" = "no"; then
>AC_CHECK_FILE(/usr/local/lib/libsqlite3.a, found=yes)
>if test "$found" = "yes"; then
>  SQLLIBS="-lsqlite3 "
>  INCLUDES="$INCLUDES -I/usr/local/include"
>  EXTRALIB='-L/usr/local/lib'
> else
>  AM_CONDITIONAL(HAVE_SQLITE, false)
>  echo ""
>  echo " 
> ---"
>  echo "| Are you SURE sqlite3 is installed?   
>  |"
>  echo "|  You need to try this:   
>  |"
>  echo "|export LDFLAGS='-L/usr/ located>'   |"
>  echo "| ./configure  
>  |"
>  echo " 
> ---"
>  echo "|  Will not compile the sqlite programs. But, why not install 
> SQLite?   |"
>  echo "|   $ wget http://www.sqlite.org/sqlite-3.2.2.tar.gz   
>  |"
>  echo " 
> ---"
>  echo ""
>fi
>  else
>SQLLIBS="$LIBS"
>LIBS=""
>  fi
> SQLIBOBJS='-Wl,-R/usr/local/lib'
> AC_SUBST(SQLIBOBJS)
> AC_SUBST(SQLLIBS)
> AC_SUBST(INCLUDES)
> AC_SUBST(EXTRALIB)
> AC_OUTPUT(Makefile)
>
>
> Below is an example of the Makefile.am that goes with the
> configure.in above.
>
> if HAVE_SQLITE
> bin_PROGRAMS = getquota setquotas quotadb
> else
> bin_PROGRAMS = getquota setquotas
> endif
>
> getquota_SOURCES = getquota.c quota.h
>
>
> setquotas_SOURCES = setquotas.c quota.h
>
>
> quotadb_SOURCES = quotadb.c quota.h
> quotadb_LDADD =  @INCLUDES@ @SQLIBOBJS@ @EXTRALIB@ @SQLLIBS@
>
>
> Hope with helps.
>
> Regards,
>
> Mike Chirico
>


--
- Doug Hanks = dhanks(at)gmail(dot)com

[sqlite] Version 3.2.7

[D. Richard Hipp]

SQLite version 3.2.7 is now available on the website.
This release fixes several obscure problems that were
discovered over the past week.  There is no rush to
upgrade unless you are having problems.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Easyer way ?

[Puneet Kishor]

On Sep 24, 2005, at 10:10 AM, Richard Nagle wrote:


Sorry, to say,
its a STACK of papers on my desk, Next to the Other several stacks,
of papers...

So, Was looking for a easier Method of getting Paper (typing) data,
into Sqlite, with out going threw all the insert...commands.



You will need to type the values at least once to convert from paper to 
bits, but you need not type in the INSERT command. Type them in Excel, 
or in a text editor... save the file as a CSV file, then load the file 
in SQLite (I believe there is a command to load CSV... if not, use the 
editor's capability to add the INSERT INTO car bit with the correct 
parens and quotes, etc.).


Make sure to quote the text, and not the numbers. Make sure the values 
are in the same order as the columns, and you won't even have to name 
the columns.



Reid Thompson wrote:

Richard Nagle wrote:

is there a easier way of typing in data to Sqlite.

sqlite> insert into car (md_num, md_name, style, year)
   ...> values (1, 'Honda', 'Coupe', 1983)
   ...> ;

Man, just 806 more listing
just looking for some short cuts, or helper apps...etc.
to cut down some of the typing.

Thanks -
Richard

do you already have the data in another format?
csv?, excel?, space delimited?
just about any consistent format can be handled via one of many of 
the scripting languages.



--
Puneet Kishor

Re: [sqlite] Easyer way ?

[Richard Nagle]

Sorry, to say,
its a STACK of papers on my desk, Next to the Other several stacks,
of papers...

So, Was looking for a easier Method of getting Paper (typing) data,
into Sqlite, with out going threw all the insert...commands.

Thanks -
Richard


Reid Thompson wrote:

Richard Nagle wrote:


is there a easier way of typing in data to Sqlite.

sqlite> insert into car (md_num, md_name, style, year)
   ...> values (1, 'Honda', 'Coupe', 1983)
   ...> ;

Man, just 806 more listing
just looking for some short cuts, or helper apps...etc.
to cut down some of the typing.

Thanks -
Richard


do you already have the data in another format?
csv?, excel?, space delimited?
just about any consistent format can be handled via one of many of the 
scripting languages.

Re: [sqlite] Including sqlite3 in a GNU project

[Mike Chirico]

On Thu, Sep 22, 2005 at 07:23:57AM -0700, Doug Hanks wrote:
> Has anyone went through (what I feel is a painful process) of adding
> sqlite in a GNU project?

The following may help, which is a small package:
   http://ftp1.sourceforge.net/souptonuts/quota_examples.tar.gz
or
   http://ftp1.sourceforge.net/cpearls/simple_but_common_cpp.tar.gz

I put the following in my configure.in or configure.am file which
checks for version 3 of sqlite.

  AC_CHECK_LIB(sqlite3,sqlite3_open,[],found=no)

This is the full configure.in file


AC_INIT(getquota.c)
AC_PROG_CXX

if test -f VERSION; then
  VERSION=`cat VERSION`
  echo "Version set to $VERSION"
else
  VERSION='0.0.0'
fi
AM_INIT_AUTOMAKE(quota_examples, $VERSION )
AC_PROG_CXX
CXXFLAGS='-Wall -W -O2 -s -pipe'
CFLAGS='-Wall -W -O2 -s -pipe'  


AM_CONDITIONAL(HAVE_SQLITE, true)
AC_CHECK_LIB(sqlite3,sqlite3_open,[],found=no)
 if test "$found" = "no"; then
   AC_CHECK_FILE(/usr/local/lib/libsqlite3.a, found=yes)
   if test "$found" = "yes"; then
 SQLLIBS="-lsqlite3 "
 INCLUDES="$INCLUDES -I/usr/local/include"
 EXTRALIB='-L/usr/local/lib'
else
 AM_CONDITIONAL(HAVE_SQLITE, false)
 echo ""
 echo " 
---"
 echo "| Are you SURE sqlite3 is installed? 
   |"
 echo "|  You need to try this: 
   |"
 echo "|export LDFLAGS='-L/usr/'   |"
 echo "| ./configure
   |"
 echo " 
---" 
 echo "|  Will not compile the sqlite programs. But, why not install 
SQLite?   |"
 echo "|   $ wget http://www.sqlite.org/sqlite-3.2.2.tar.gz 
   |"
 echo " 
---" 
 echo ""
   fi
 else
   SQLLIBS="$LIBS"
   LIBS=""
 fi
SQLIBOBJS='-Wl,-R/usr/local/lib'
AC_SUBST(SQLIBOBJS)
AC_SUBST(SQLLIBS)
AC_SUBST(INCLUDES)
AC_SUBST(EXTRALIB)
AC_OUTPUT(Makefile)


Below is an example of the Makefile.am that goes with the 
configure.in above.

if HAVE_SQLITE
bin_PROGRAMS = getquota setquotas quotadb
else
bin_PROGRAMS = getquota setquotas 
endif

getquota_SOURCES = getquota.c quota.h


setquotas_SOURCES = setquotas.c quota.h


quotadb_SOURCES = quotadb.c quota.h
quotadb_LDADD =  @INCLUDES@ @SQLIBOBJS@ @EXTRALIB@ @SQLLIBS@


Hope with helps. 

Regards,

Mike Chirico

[sqlite] Xtudio C/C++ IDE - free IDE is ready for download

[Eran Ifrah]

Hi All,

What is Xtudio? Xtudio is a C/C++ code editor for windows programmers, you can 
learn more about it here:
http://www.eistware.com


The Alpha version has just released downloaded FREE 
from http://www.eistware.com/Download.html


Xtudio IDE is for Windows users (Tested on XP SP1 / 2) that uses C/C++ 
It is totaly free (no trials, no 30 days, no commitments etc.)


Xtudio demonstrates the power of Scintilla as an editing 
component and using SQLite engine for internal DB. 


Xtudio introduces some unique features for editing code and compiling it.

Visit us at:
http:://www.eistware.com

Downloads:
http://www.eistware.com/Download.html

Forum:
http://www.eistware.com/forum/index.php

For mails and responses:
[EMAIL PROTECTED] 


Enjoy,
mailto:[EMAIL PROTECTED] 

[sqlite] compression

[Martin Pfeifle]

Hello,
does anybody know whether it is possible to compress
sqlite data on the page level. If I compress the
sqlite database file with zlib I get very high
compression rates due to the character of the stored
data.
I think this problem is related to the problem of
using encrypted databases. Perheps it is possible just
to exchange the encryption function call by a zlib
compression call.
Integrating such a call simply into the read and write
functions in the file os_win.c does not work.
Can anybody help me, or give me a hint?
Ciao Martin



___ 
Was denken Sie über E-Mail? Wir hören auf Ihre Meinung: 
http://surveylink.yahoo.com/wix/p0379378.aspx