[sqlite] New Project: PyDAO - For SQLite

[R.A. Nagy]

SQLite devotees interested in Python might like to know of a new *GitHub
Project*.

Designed to generate the code required - as well as to import - data into
an SQLite Database, please allow us to direct your weekend-warrior
activities toward our *PyDAO* Project under *Soft9000*.

SQL-Geeks interested in Java might like to look at the SqlMate project on
GitHub, as well.


Yours in professional software developer education!

-- Randall

https://github.com/soft9000/PyDAO
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Education Opportunity Alert: The SQL Primer

[R.A. Nagy]

Hi all,

Let me begin by thanking everyone for the feedback on the YouTube video
effort!

For those who would like to revisit our relatively comprehensive update to
a professional introduction to SQL & SQLite, please feel free to share &
enjoy =) this latest:

https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy

Comments & suggestion for improvement be both respected, as well as
appreciated here, as usual!


Cheers,

Randall Nagy
President, Soft9000.com
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL to SQLite

[R.A. Nagy]

If you are into Java, then I have a source code generator that should do
the trick:

https://sourceforge.net/projects/sqlmate/?source=directory

All one need do is to use the main.java included in the archive to generate
the DAO, then create two connection strings - one for each database file.

Using JDBC one could then connect to both files, then copy one set of data
using the generated code between the two database Connection()s.

Easy-peasy!  =)


On Wed, Jul 20, 2016 at 4:48 PM, Robby Helperin <r...@spotlightmusic.com>
wrote:

> Thanks R.A.Nagy.
>
> Would you be able to provide a quick example of what you mean?
>
> What I ended up doing was iterating through the rows and columns of the SQL
> database and creating a string that would later be used as an SQLite Insert
> command.  Seemed like that was the long way around.
>
> If there's a way to construct a command that in one step takes from one SQL
> database and writes to a SQLite database, I'd like to see an example of
> that
> syntax.
>
> Thanks.
>
> -Original Message-
> From: sqlite-users-boun...@mailinglists.sqlite.org
> [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.A.
> Nagy
> Sent: Wednesday, July 20, 2016 7:25 AM
> To: SQLite mailing list
> Subject: Re: [sqlite] SQL to SQLite
>
> There are several ways to work with other databases. From the SQLite, we
> can
> always attach another file so as to work with > 1 database file at a time.
> From a programmatic point of view, one simply uses yet another database
> connection to do the same thing.
>
>
>
>
>
>
> On Tue, Jul 19, 2016 at 7:21 PM, Robby Helperin <r...@spotlightmusic.com>
> wrote:
>
> > Thanks for your response.
> >
> > Programming language is definitely the way I want to go, and in fact I
> > programmed a workaround, but I assume I took the long way around and
> > that there's a more standard way to do it.
> >
> > Any SQLite string is going to refer to just one database, so you can't
> > write an INSERT command that will take from one database and write to
> > another, or can you?  How would this normally done?
> >
> > -Original Message-
> > From: sqlite-users-boun...@mailinglists.sqlite.org
> > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.A.
> > Nagy
> > Sent: Tuesday, July 19, 2016 3:32 PM
> > To: SQLite mailing list
> > Subject: Re: [sqlite] SQL to SQLite
> >
> > Surely the best way to routinely & autocratically copy a set of data
> > from one database to another SQL technology would be to use a
> > programming language - like Java, C/C++, C#, or Python for example -
> > so as to copy data between two different database connections.
> >
> > The only other way would be to create a textual .dump or CSV (etc)
> > export file, then munge the data for a clear-text importation via any
> > data migration tools available for the foreign SQL 'tech.
> >
> > Here is an explanation of how to do the later for SQLite:
> > https://www.youtube.com/watch?v=bVq57NBOaLs
> >
> >
> >
> >
> >
> > On Tue, Jul 19, 2016 at 6:01 PM, <tm...@spotlightmusic.com> wrote:
> >
> > > What's the best way to Insert or Update records from a connected SQL
> > > database to the connected SQLite database?
> > >
> > >
> > >
> > > I don't mean just once, but to do every so often.
> > >
> > >
> > >
> > > Thanks.
> > >
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL to SQLite

[R.A. Nagy]

There are several ways to work with other databases. From the SQLite, we
can always attach another file so as to work with > 1 database file at a
time. From a programmatic point of view, one simply uses yet another
database connection to do the same thing.






On Tue, Jul 19, 2016 at 7:21 PM, Robby Helperin <r...@spotlightmusic.com>
wrote:

> Thanks for your response.
>
> Programming language is definitely the way I want to go, and in fact I
> programmed a workaround, but I assume I took the long way around and that
> there's a more standard way to do it.
>
> Any SQLite string is going to refer to just one database, so you can't
> write
> an INSERT command that will take from one database and write to another, or
> can you?  How would this normally done?
>
> -Original Message-
> From: sqlite-users-boun...@mailinglists.sqlite.org
> [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.A.
> Nagy
> Sent: Tuesday, July 19, 2016 3:32 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] SQL to SQLite
>
> Surely the best way to routinely & autocratically copy a set of data from
> one database to another SQL technology would be to use a programming
> language - like Java, C/C++, C#, or Python for example - so as to copy data
> between two different database connections.
>
> The only other way would be to create a textual .dump or CSV (etc) export
> file, then munge the data for a clear-text importation via any data
> migration tools available for the foreign SQL 'tech.
>
> Here is an explanation of how to do the later for SQLite:
> https://www.youtube.com/watch?v=bVq57NBOaLs
>
>
>
>
>
> On Tue, Jul 19, 2016 at 6:01 PM, <tm...@spotlightmusic.com> wrote:
>
> > What's the best way to Insert or Update records from a connected SQL
> > database to the connected SQLite database?
> >
> >
> >
> > I don't mean just once, but to do every so often.
> >
> >
> >
> > Thanks.
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL to SQLite

[R.A. Nagy]

Surely the best way to routinely & autocratically copy a set of data from
one database to another SQL technology would be to use a programming
language - like Java, C/C++, C#, or Python for example - so as to copy data
between two different database connections.

The only other way would be to create a textual .dump or CSV (etc) export
file, then munge the data for a clear-text importation via any data
migration tools available for the foreign SQL 'tech.

Here is an explanation of how to do the later for SQLite:
https://www.youtube.com/watch?v=bVq57NBOaLs





On Tue, Jul 19, 2016 at 6:01 PM,  wrote:

> What's the best way to Insert or Update records from a connected SQL
> database to the connected SQLite database?
>
>
>
> I don't mean just once, but to do every so often.
>
>
>
> Thanks.
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding file extension for sqlite command prompt

[R.A. Nagy]

Use .read to load & execute .sql files.

The .open is for databases, not external / textual command files.

Here are some introductory videos:

https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy



On Fri, Jun 24, 2016 at 6:07 AM, Kaja Varunkumar 
wrote:

> Hello,
>
>  I am new to SQLite, I have seen the  commands for command prompt of
> SQLite. I have some query files with format .sql. Whenever I try to open
> the files using command .open and read the files . I am getting an error of
> file encrypted and not in the database.   My question's, are there any
> format to open files in SQLite? After creating the tables in one session
> that are not shown in another session.  How to avoid this case ?
>
>
> Thanks,
>  K Varun Kumar
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite Logo

[R.A. Nagy]

I am putting together a commercial training for SQLite. I would like to use
the SQLite logo - as seen on the website - on the cover of the materials.

Can do?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Final preparations for the release of System.Data.SQLite v1.0.102.0 have begun...

[R.A. Nagy]

... neither did the Vulcan high command ...  ;-)

On Wed, Jun 15, 2016 at 2:07 PM, R Smith  wrote:

> Bit of an unfair deadline there Joe, Einstein didn't think it plausible.
>
>
>
> On 2016/06/15 7:53 PM, Joe Mistachkin wrote:
>
>> If you have any issues with the current code, please report them via this
>> mailing
>> list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
>> prior to
>> Friday, April 15th.
>>
>> Thanks.
>>
>> --
>> Joe Mistachkin
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Update DataGrid and Save to database

[R.A. Nagy]

Most people seem to prefer black these days, but white is cooler. Reflects,
rather than absorbs, heat.

Of course, if you live up north that might be a bad thing. Here in the
south, all is well...



On Mon, Jun 13, 2016 at 9:31 AM, Chris Locke 
wrote:

> Great analogy.  PS: What colour seat covers should I be using if I have a
> Ford?
>
> On Mon, Jun 13, 2016 at 2:11 PM, jumper  wrote:
>
> > Thank you for the advice/information. I just solved the issue about a
> > minute ago. How can I stop getting new replies?
> >
> >
> > On 6/13/2016 8:08 AM, R Smith wrote:
> >
> >>
> >>
> >> On 2016/06/13 2:48 PM, jumper wrote:
> >>
> >>> New to SQLite and DataGrids. I need to know how to get an adapter,
> table
> >>> and dataset when app first comes up.
> >>> Then when someone updates the DataGrid I need to save the changes to
> the
> >>> database.
> >>>
> >>> I've been working on this for days and can't do it. Could someone
> please
> >>> post the code for how to do it?
> >>> Thank you so much,
> >>>
> >>
> >> Hi John,
> >>
> >> These questions you ask are about creating user-interfaces for databases
> >> and adapters in some GUI systems - none of which is remotely related to
> the
> >> inner workings of the SQLite DB engine or answerable on this forum. It's
> >> like you want to know where the gas pedal and steering wheel is in your
> >> car, and now contacting the Engine manufacturer to ask. We don't really
> >> know.
> >>
> >> I'm assuming the platforms you use may be MSVC, C++ or Delphi or some
> >> other GUI type creator - try their forum or community, or perhaps even a
> >> google search for a tutorial stating exactly the tools you use.
> >>
> >>
> >> Good luck!
> >> Ryan
> >>
> >>
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users@mailinglists.sqlite.org
> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >>
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL / SQLite for Beginners

[R.A. Nagy]

That was what I was trying to say - thanks for the superior spelling.

Also - for wee Java folks, I cobbled together a CRUD generator for SQLite
last night:

https://sourceforge.net/projects/sqlmate

Also on:

https://github.com/soft9000/SQLMate



Sharing is caring,


-Rn





On Tue, Jun 7, 2016 at 12:24 AM, James K. Lowden 
wrote:

> On Thu, 26 May 2016 10:54:30 -0400
> r.a.n...@gmail.com wrote:
>
> > FWIW, since it's inception, S.Q.L has been pronounced allot like
> > CICS.
>
> This may be more true than you know.  It's not too hard to find
> old-timers who pronounce it "kicks".
>
> --jkl
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Messages posted on Nabble not getting to list

[R.A. Nagy]

FWIW, we are VERY socialized - from Linkedin & Twitter, to YouTube &
Facebook (we've about 5 groups there,) over to Sourceforge.NET, Stack
Overflow (and of course ... here!), it all eventually gets forwarded to
this email account somehow ... even if I have to write a scraper to do it.

There is just not enough hours in the day to do otherwise

.02 ends




On Fri, May 27, 2016 at 1:23 AM, Jean-Christophe Deschamps  wrote:

>
> At 03:46 27/05/2016, you wrote:
>
>> If SQLite goes this route, I will probably (as with the others) stop
>> reading it too.
>>
>
> Seconded.
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL / SQLite for Beginners

[R.A. Nagy]

Would this be the preferred pronunciation?

 https://youtu.be/hB54p_Xh37M


Thanks in advance,

-Rn


On Wed, May 25, 2016 at 1:55 PM, R.A. Nagy <r.a.n...@gmail.com> wrote:

> Excellent suggestion.
>
> I have an SQLite forJava eLearning title presently under way (JDBC &
> Hibernate) - can salvage a section we have on Views for re-use on the
> YouTube playlist, as well.
>
> Thanks for the inspiration,
>
> -Rn
>
>
> On Wed, May 25, 2016 at 1:49 PM, Chris Brody <chris.br...@gmail.com>
> wrote:
>
>> Another piece of feedback: I think it would be people to have access to
>> the
>> presentation slides and samples.
>>
>> Having JOIN for beginners is great. I think it would be cool to have VIEWs
>> for beginners as well. These are major benefits over NoSQL.
>> On May 22, 2016 1:29 PM, "R.A. Nagy" <r.a.n...@gmail.com> wrote:
>>
>> > All,
>> >
>> > A recent convert to using SQLite, I have put together a series of
>> videos on
>> > learning SQL, as well as covering the basics of using SQLite.
>> >
>> >
>> https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy
>> >
>> > Would this be the proper mailing list / way to let new-users learn more
>> > about these videos? If so - and in as much as forum members here field
>> > allot of new-user questions - then any suggestions for improving the
>> > presentations would also be welcome.
>> >
>> >
>> > Thanks in advance,
>> >
>> > Randall Nagy
>> > President, Soft9000.com
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@mailinglists.sqlite.org
>> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>> >
>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL / SQLite for Beginners

[R.A. Nagy]

Excellent suggestion.

I have an SQLite forJava eLearning title presently under way (JDBC &
Hibernate) - can salvage a section we have on Views for re-use on the
YouTube playlist, as well.

Thanks for the inspiration,

-Rn


On Wed, May 25, 2016 at 1:49 PM, Chris Brody <chris.br...@gmail.com> wrote:

> Another piece of feedback: I think it would be people to have access to the
> presentation slides and samples.
>
> Having JOIN for beginners is great. I think it would be cool to have VIEWs
> for beginners as well. These are major benefits over NoSQL.
> On May 22, 2016 1:29 PM, "R.A. Nagy" <r.a.n...@gmail.com> wrote:
>
> > All,
> >
> > A recent convert to using SQLite, I have put together a series of videos
> on
> > learning SQL, as well as covering the basics of using SQLite.
> >
> > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy
> >
> > Would this be the proper mailing list / way to let new-users learn more
> > about these videos? If so - and in as much as forum members here field
> > allot of new-user questions - then any suggestions for improving the
> > presentations would also be welcome.
> >
> >
> > Thanks in advance,
> >
> > Randall Nagy
> > President, Soft9000.com
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL / SQLite for Beginners

[R.A. Nagy]

Cool.

Thanks!


On Wed, May 25, 2016 at 1:18 PM, Jeffrey Mattox <j...@mac.com> wrote:

> The concept is good, but I immediately noticed your pronunciation of
> SQLite and recall the recent discussion about that.  The conclusion was
> that any pronunciation is okay, but I think the the most common is
> "es-que-el-ite" (and that's Dr. Hipp's).  My point is, I was distracted
> throughout the video by the lesser-used alternative and I wonder if that
> will distract others, too, from the content.
>
> Jeff
>
>
> > On May 22, 2016, at 6:29 AM, R.A. Nagy <r.a.n...@gmail.com> wrote:
> >
> > All,
> >
> > A recent convert to using SQLite, I have put together a series of videos
> on
> > learning SQL, as well as covering the basics of using SQLite.
> >
> > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy
> >
> > Would this be the proper mailing list / way to let new-users learn more
> > about these videos? If so - and in as much as forum members here field
> > allot of new-user questions - then any suggestions for improving the
> > presentations would also be welcome.
> >
> >
> > Thanks in advance,
> >
> > Randall Nagy
> > President, Soft9000.com
> > ___
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL / SQLite for Beginners

[R.A. Nagy]

Great responses there guys - Just what I was looking for.

The "typeallot" format was what I was wondering about. Looks like it was
not such a good idea on my part.

Thanks for the feedback!





On Wed, May 25, 2016 at 12:54 PM, R Smith <rsm...@rsweb.co.za> wrote:

>
>
> On 2016/05/25 6:29 PM, Cousin Stanley wrote:
>
>> R.A. Nagy wrote:
>>
>> All,
>>>
>>> A recent convert to using SQLite, I have put together a series of videos
>>> on learning SQL, as well as covering the basics of using SQLite.
>>>
>>>
>>> https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy
>>>
>>> Would this be the proper mailing list / way to let new-users
>>> learn more about these videos ?
>>>
>>I can't speak to what is  proper  for this mailing list
>>since I am only an interested casual regular reader
>>of the list 
>>
>>
>> If so - and in as much as forum members here field
>>> a lot of new-user questions - then any suggestions
>>> for improving the presentations would also be welcome.
>>> 
>>>
>>I only viewed the first few minutes of the first video
>>listed at your youtube site and thought it started out
>>very well and was well presented 
>>
>>  DIY SQLite:  Fast Start to Learning SQL
>>
>>However, when you switched from a narrative mode
>>to a musical background with no narrative,
>>you lost me 
>>
>>Just my personal opinion, but I would be inclined
>>to lose the music and retain a narrative throughout
>>the series 
>>
>
> I'll second this - it was good with the narrative - very basic and quite
> thorrough help for a real newbie, but as soon as you have to both read and
> watch the commands, it becomes a bit of a labour to keep with it. The
> content is great though.  Why not more narratives? Are you shy? :)
>
> Put differently, if you do the same stuff, but with more narratives like
> the first, I will gladly point people that way from now on and list it on
> my things as a great SQLite resource.
>
> Cheers,
> Ryan
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Get Longitude and Latitude using PHP

[R.A. Nagy]

This is a SQLite forum. Not Android.

But yes, you can get a latlng from Google Earth, but I would query the
device.
On May 24, 2016 12:00 PM, "Gary Ehrenfeld"  wrote:

I want to use PHP to get the Longitude and Latitude from a Address then use
google maps to display it.

I have it working, but the user has to know what their Lat and Long are.

What I want is I can get the Lat and Long from their address and display
the map form then.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL logic error or missing database no such table

[R.A. Nagy]

We only use .commit when we are using transactions: If any type of "BEGIN
TRANSACTION;" is underway, a failure to "COMMIT;" data will guarantee that
data will not be in a database. Interestingly however, even when not
committed our queries will still work - our data will simply not be
available in the next session if we do not .commit our changes.

FWIW: No matter our language-binding technology, I always advise folks to
use a .close operation when provided for any type of statements, as well as
connections. While we can often get away with not doing so, from a cross
'tech point of view - and from JDBC to those .NET bindings - using .close
it is simply a good thing to get used to doing.





On Mon, May 23, 2016 at 2:21 PM, Rajendra Shirhatti <rrshirha...@gmail.com>
wrote:

> Yes, I'm very positive the data is stored otherwise the application would
> throw some exception.
> The database is encrypted by calling passing a private key to the
> connection using ChangePassword().
>
> Thank you, Raj
>
> On Mon, May 23, 2016 at 9:16 AM, R.A. Nagy <r.a.n...@gmail.com> wrote:
>
> > Are we sure that data are being stored at-all?
> >
> > Also, how is the database being encrypted?
> >
> >
> > On Sun, May 22, 2016 at 3:02 PM, Rajendra Shirhatti <
> rrshirha...@gmail.com
> > >
> > wrote:
> >
> > > Hi Randall,
> > > Thank you so much for your reply.
> > > I don't have enough data to confirm whether database file is missing or
> > > it's due to some other reason.
> > > According to my initial investigation, it looks like the application is
> > > able to create database and perform all the operations successfully
> upon
> > > service start. I'm leaning towards the possibility that the tables are
> > > somehow getting deleted or the database file becomes inaccessible when
> > the
> > > service is RESTARTED. We open the database connection during service
> > > startup and it stays alive as long as service is running.
> > > Is there any scenario that could corrupt the database because the
> > > connection was not closed successfully?
> > >
> > > Thank you once again.
> > >
> > > -Raj
> > >
> > > On Sun, May 22, 2016 at 4:54 AM, R.A. Nagy <r.a.n...@gmail.com> wrote:
> > >
> > > > Try:
> > > >
> > > > .schema [tablename]
> > > >
> > > > Since there is probably nothing there, you probably need to create a
> > > table.
> > > >
> > > > If you are new to SQL / SQLite, then here are some helpful videos:
> > > >
> > > >
> > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy
> > > >
> > > >
> > > > Cheers,
> > > >
> > > > -Randall Nagy
> > > > President, Soft9000.com
> > > >
> > > >
> > > >
> > > >
> > > > On Sat, May 21, 2016 at 4:09 PM, Rajendra Shirhatti <
> > > rrshirha...@gmail.com
> > > > >
> > > > wrote:
> > > >
> > > > > Hi,
> > > > > We've a .Net Windows Service that uses SQLite 1.0.93.0 for database
> > > > > operations. The SQLite package contains two binaries,
> > > > > system.data.sqlite.dll and sqlite.interop.dll.
> > > > >
> > > > > The database is encrypted and the blob it contains is encrypted as
> > > well.
> > > > > SQLite is intermittently throwing following exceptions while
> > retrieving
> > > > > data from the database.
> > > > >
> > > > >
> > > > >- *SQL logic error or missing database no such table*.
> > > > >
> > > > >  The code is trying to execute a simple query which looks something
> > > like
> > > > > this:
> > > > >  SELECT x, y from [tablename]
> > > > >
> > > > > This exception is raised while executing
> > SQLiteCommand.ExecuteReader().
> > > > The
> > > > > stack trace points to
> > > > > at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String
> > > > strSql,
> > > > > SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
> > > > > at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
> > > > > at System.Data.SQLite.SQLiteDataReader.NextResult()
> > > > >
> > > > >
> > > > >
> > > > > * - Data Source cannot be 

[sqlite] SQL logic error or missing database no such table

[R.A. Nagy]

Are we sure that data are being stored at-all?

Also, how is the database being encrypted?


On Sun, May 22, 2016 at 3:02 PM, Rajendra Shirhatti 
wrote:

> Hi Randall,
> Thank you so much for your reply.
> I don't have enough data to confirm whether database file is missing or
> it's due to some other reason.
> According to my initial investigation, it looks like the application is
> able to create database and perform all the operations successfully upon
> service start. I'm leaning towards the possibility that the tables are
> somehow getting deleted or the database file becomes inaccessible when the
> service is RESTARTED. We open the database connection during service
> startup and it stays alive as long as service is running.
> Is there any scenario that could corrupt the database because the
> connection was not closed successfully?
>
> Thank you once again.
>
> -Raj
>
> On Sun, May 22, 2016 at 4:54 AM, R.A. Nagy  wrote:
>
> > Try:
> >
> > .schema [tablename]
> >
> > Since there is probably nothing there, you probably need to create a
> table.
> >
> > If you are new to SQL / SQLite, then here are some helpful videos:
> >
> > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy
> >
> >
> > Cheers,
> >
> > -Randall Nagy
> > President, Soft9000.com
> >
> >
> >
> >
> > On Sat, May 21, 2016 at 4:09 PM, Rajendra Shirhatti <
> rrshirhatti at gmail.com
> > >
> > wrote:
> >
> > > Hi,
> > > We've a .Net Windows Service that uses SQLite 1.0.93.0 for database
> > > operations. The SQLite package contains two binaries,
> > > system.data.sqlite.dll and sqlite.interop.dll.
> > >
> > > The database is encrypted and the blob it contains is encrypted as
> well.
> > > SQLite is intermittently throwing following exceptions while retrieving
> > > data from the database.
> > >
> > >
> > >- *SQL logic error or missing database no such table*.
> > >
> > >  The code is trying to execute a simple query which looks something
> like
> > > this:
> > >  SELECT x, y from [tablename]
> > >
> > > This exception is raised while executing SQLiteCommand.ExecuteReader().
> > The
> > > stack trace points to
> > > at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String
> > strSql,
> > > SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
> > > at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
> > > at System.Data.SQLite.SQLiteDataReader.NextResult()
> > >
> > >
> > >
> > > * - Data Source cannot be empty. Use :memory: to open an in-memory
> > > database- unable to open database file *
> > >
> > > These two exceptions are raised while trying to open the connection.
> > >
> > >
> > >  Any help or guidance would be appreciated.
> > >
> > > Thank you,
> > > Raj
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users at mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] SQL logic error or missing database no such table

[R.A. Nagy]

Try:

.schema [tablename]

Since there is probably nothing there, you probably need to create a table.

If you are new to SQL / SQLite, then here are some helpful videos:

https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy


Cheers,

-Randall Nagy
President, Soft9000.com




On Sat, May 21, 2016 at 4:09 PM, Rajendra Shirhatti 
wrote:

> Hi,
> We've a .Net Windows Service that uses SQLite 1.0.93.0 for database
> operations. The SQLite package contains two binaries,
> system.data.sqlite.dll and sqlite.interop.dll.
>
> The database is encrypted and the blob it contains is encrypted as well.
> SQLite is intermittently throwing following exceptions while retrieving
> data from the database.
>
>
>- *SQL logic error or missing database no such table*.
>
>  The code is trying to execute a simple query which looks something like
> this:
>  SELECT x, y from [tablename]
>
> This exception is raised while executing SQLiteCommand.ExecuteReader(). The
> stack trace points to
> at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql,
> SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
> at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
> at System.Data.SQLite.SQLiteDataReader.NextResult()
>
>
>
> * - Data Source cannot be empty. Use :memory: to open an in-memory
> database- unable to open database file *
>
> These two exceptions are raised while trying to open the connection.
>
>
>  Any help or guidance would be appreciated.
>
> Thank you,
> Raj
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] SQL / SQLite for Beginners

[R.A. Nagy]

All,

A recent convert to using SQLite, I have put together a series of videos on
learning SQL, as well as covering the basics of using SQLite.

https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy

Would this be the proper mailing list / way to let new-users learn more
about these videos? If so - and in as much as forum members here field
allot of new-user questions - then any suggestions for improving the
presentations would also be welcome.


Thanks in advance,

Randall Nagy
President, Soft9000.com

[sqlite] Signed version of System.Data.SQLite.dll

[R.A. Nagy]

Actually, one can code-sign things without re-compiling them. Just download
your certificate, create a key store, then get the tools.

You will also probably need to have a link to your CA, as well.



On Fri, May 20, 2016 at 10:58 AM, Matthias-Christian Ott 
wrote:

> On 2016-05-20 01:55, Gaurav Batra wrote:
> > From where I can get the signed binaries?
>
> I would suggest to compile SQLite and System.Data.SQLite yourself and
> sign it yourself. It's not hard. It's likely also the most secure
> solution. You will need a code signing certificate. If your employer has
> such policies, purchasing a code signing certificate should not be a
> problem though.
>
> - Matthias-Christian
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] sqlite3_prepare*() statement argument detailed

[R.A. Nagy]

SQL statements end with a ";"

That is what is meant by "statement."



On Mon, May 16, 2016 at 8:58 AM, E.D.  wrote:

> Hi.
>
> The sqlite3 documentation specifies, that sqlite3_prepare*() compile "the
> first statement" from the sqlite3_stmt ** argument. This argument ought to
> be explained thoroughly.
> What exactly can be put through this argument? Compound statements,
> transactions? What syntax?
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>