Re: [sqlite] confused getting started

2017-03-07 Thread Cezary H. Noweta
Hello, On 2017-03-05 01:10, John Albertini wrote: I can't seem to grasp what I need to download / install to use SQLite? Can someone guide me through the process? Looking to use it with RootsMagic. If you want to use a tool like dBaseIII+ to examine/modify a database created by a 3rd

Re: [sqlite] confused getting started

2017-03-06 Thread J Decker
On Mon, Mar 6, 2017 at 8:40 PM, Jens Alfke wrote: > > > On Mar 6, 2017, at 7:57 PM, J Decker wrote: > > > > Pretty silly since it is sqlite, and a mmap'ed database is pretty much > > sync > > Not really. The data still has to be paged in off the disk,

Re: [sqlite] confused getting started

2017-03-06 Thread Jens Alfke
> On Mar 6, 2017, at 7:57 PM, J Decker wrote: > > Pretty silly since it is sqlite, and a mmap'ed database is pretty much > sync Not really. The data still has to be paged in off the disk, which can take arbitrarily long (seconds, if the system is under heavy load), and

Re: [sqlite] confused getting started

2017-03-06 Thread J Decker
If Python is appealing then Node.js + sqlite adapter makes sqlite very easy. I have my own https://www.npmjs.com/package/sack.vfs Needs better docs on the Sqlite output I guess A more proper package that's all promises and async stuff... https://www.npmjs.com/package/sqlite Pretty

Re: [sqlite] confused getting started

2017-03-06 Thread R Smith
On 2017/03/05 1:03 PM, NTrewartha T-Online wrote: I too am new to DB's and Sqllite. Welcome! There is a GUI tool - which I think is better for learners which ought to be mentioned. http://sqlitebrowser.org/ The "DBBrowser for sqllite". DBBrowser for SQlite is great, and cross-platform.

Re: [sqlite] confused getting started

2017-03-06 Thread Chris Locke
NT- I write a lot of vb.net programs that use sqlite databases, so will be happy to run though a beginners guide. It would be painless to convert from vb.net to c# Thanks, Chris ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] confused getting started

2017-03-06 Thread Bob Friesenhahn
On Sun, 5 Mar 2017, Jens Alfke wrote: No offense intended, but SQLite isn’t an especially beginner-friendly tool. It’s a powerful relational database with a ton of configurable options, and a somewhat tricky C API, not to mention a sophisticated query language that you also need to master to

Re: [sqlite] confused getting started

2017-03-05 Thread Barry Smith
A less LMGTFY-like response: First off, using SQLite does require that you become familiar with SQL, and a bunch of database ideas: normalization for good schema design, unit of work for good use of transactions, how to use indexes, others I'm sure I don't know about. But those ideas are not

Re: [sqlite] confused getting started

2017-03-05 Thread Jens Alfke
> On Mar 5, 2017, at 3:03 AM, NTrewartha T-Online > wrote: > > Any examples of a C,C++,C# or Python usage for sqllite.? Have you tried searching? I entered “sqlite c example” and “sqlite python example” into Google and got some useful-looking links in the top few

Re: [sqlite] confused getting started

2017-03-05 Thread dmp
> I'm not a computer novice, but also not a nerd/geek. > Been using PCs since the mid 1980s and have used dBase III+ and Approach > previously. > > I can't seem to grasp what I need to download / install to use SQLite? > > Can someone guide me through the process? Looking to use it with >

Re: [sqlite] confused getting started

2017-03-05 Thread NTrewartha T-Online
ffer. HTH. -- Adolfo Mensaje original De: John Albertini <john.albert...@gmail.com> Para: sqlite-users@mailinglists.sqlite.org Fecha: Sat, 4 Mar 2017 19:10:26 -0500 Asunto: [sqlite] confused getting started I'm not a computer novice, but also not a nerd/geek. Been using PCs sin

Re: [sqlite] confused getting started

2017-03-05 Thread ajm
. -- Adolfo > > Mensaje original > De: John Albertini <john.albert...@gmail.com> > Para: sqlite-users@mailinglists.sqlite.org > Fecha: Sat, 4 Mar 2017 19:10:26 -0500 > Asunto: [sqlite] confused getting started > > I'm not a computer novice, but also not a ne

Re: [sqlite] confused getting started

2017-03-04 Thread Simon Slavin
On 5 Mar 2017, at 12:10am, John Albertini wrote: > I'm not a computer novice, but also not a nerd/geek. > > Been using PCs since the mid 1980s and have used dBase III+ and Approach > previously. > > I can't seem to grasp what I need to download / install to use

[sqlite] confused getting started

2017-03-04 Thread John Albertini
I'm not a computer novice, but also not a nerd/geek. Been using PCs since the mid 1980s and have used dBase III+ and Approach previously. I can't seem to grasp what I need to download / install to use SQLite? Can someone guide me through the process? Looking to use it with RootsMagic. Thank