subject:"Re\: \[sqlite\] Newbie Question"

Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Dave

Michael,

#1 Thanks for the comments. I have the book, The Definitive Guide to
SQLite from Apress by Michael Owens, but it is the 2006 first edition.
Do you, or anyone, know if the new or 2nd edition is worth buying or
does it just cover 1 new item? I am not afraid to buy books. You should
see my VB6 collection. :) Can you recommend a must have well written
database design book?

#2 Believe me, I know it is hard to get out of my VB6 and if I knew it
would work forever, I probably wouldn't. But Microsoft dropped support
years ago. I started with a TI994A and moved up to a Commodore C64 and
actually ran a BBS with SCSI hard drives attached to it. Did the same
with a Commodore C128. Still have the equipment and it still works. I
build all my computers. I have the Visual Studio Pro so I can look at C#
but I had C++ in my Classic Studio and stayed with Visual Basic. For my
needs it is powerful enough.

#3 This list has helped me get set up as I found the old ADO provider
(1.0.66) and had some questions on the correct package to download from
the System.Data.SQLite. Then the designer was missing but now I see it
is almost ready and will come out next release. That is good.

My database needs or wants are simple at the present time. When I wrote
my main app that is shareware I couldn't quite figure out the data base
stuff and I also was worried someone would just steal my data base and
use it to form a competing product. The password with Access seemed easy
to break if you Googled it. So I hard coded my data into the app but
that made it a bunch of extra work to add new items in the proper order
that was necessary as there were multiple fields. As I rewrite the app,
the main reason for all this upgrading, I will surely come up with new
situations and challenges. Simple things come to mind like allowing the
end user to change the data, but if they muck it up, allow them to get
back to the default data base. My app deals with formulas that require
accuracy and hard coding data preserves that.

The another reason I stayed away from .NET as I read how easy it was for
people to steal your hard work. I read about Obfuscation and it seemed
like it may or may not work all that good, but it looks like that is all
we have so I have to trust it. Visual Studio Pro comes with a standard
or basis Obfuscator but I have found other ones for free and some
costing in the thousands.

Dave

On 11/29/2011 6:17 AM, Black, Michael (IS) wrote:

I'll note a few things here...

#1 If you want to learn about "database design" or "how to code in language X"
get a book on those and not on a particular product (you may want the product book too if you need
it but those tend to be less helpful).

#2 Your first language will be hard to get "out of". I've done over 60
languages now and C# is one of only a few that I was impressed with and worth the trouble
to learn. Ada was the other one (but for completely different reasons). I still prefer
C though C++ can be more helpful at times (advanced data structures).

#3 This list is probably one of the best learning things you can do that doesn't take "study
time". When somebody poses a problem try to solve it yourself without seeing the
"answer" that inevitably comes up here. One of the better ways of learning is doing.

Michael D. Black

Senior Scientist

Advanced Analytics Directorate

Advanced GEOINT Solutions Operating Unit

Northrop Grumman Information Systems

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

Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Alaric Snell-Pym

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 11/29/2011 12:17 PM, Black, Michael (IS) wrote:
> I'll note a few things here...

[snip]

Much good advice. Seconded!

ABS

- --
Alaric Snell-Pym
http://www.snell-pym.org.uk/alaric/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7UzwwACgkQRgz/WHNxCGo8YQCfbuHuGn+TswVZvoaBdKvvUTfc
LuIAnRklSLS0P/KgE29lF6GHuvlnnonq
=U2zn
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Black, Michael (IS)

I'll note a few things here...

#1 If you want to learn about "database design" or "how to code in language X" 
get a book on those and not on a particular product (you may want the product 
book too if you need it but those tend to be less helpful).

#2 Your first language will be hard to get "out of".  I've done over 60 
languages now and C# is one of only a few that I was impressed with and worth 
the trouble to learn.  Ada was the other one (but for completely different 
reasons).  I still prefer C though C++ can be more helpful at times (advanced 
data structures).

#3 This list is probably one of the best learning things you can do that 
doesn't take "study time".  When somebody poses a problem try to solve it 
yourself without seeing the "answer" that inevitably comes up here.  One of the 
better ways of learning is doing.

Michael D. Black

Senior Scientist

Advanced Analytics Directorate

Advanced GEOINT Solutions Operating Unit

Northrop Grumman Information Systems

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Dave [thesche...@cox.net]
Sent: Monday, November 28, 2011 5:24 PM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Newbie question on Data Source

On 11/28/2011 4:59 PM, Simon Slavin wrote:
> On 28 Nov 2011, at 10:44pm, Dave wrote:
>
>> On 11/28/2011 4:37 PM, Simon Slavin wrote:
>>> Just to stress that the filename includes the bit after the '.'.  You can 
>>> have any number of files with the same part before the '.' but different 
>>> extensions.  To tell the operating system which one you want you must 
>>> include the bit after the '.'.
>>   Actually, I knew that. Just having a bit of a multiple crash course...all 
>> at once. I just recently built this pc and have been on XP until recently 
>> too. I do some graphic stuff and have many same named pics with the various 
>> .jpg, .bmp, .gif extensions.
> My job involves dealing with lots of people who aren't good at computers and 
> the fact that, by default, the OS hides file extensions confuses the hell out 
> of them.  I'm not taking a shot at Windows here: the Macintosh OS does the 
> same thing.
>
> It also means you see files with names like 'paper.doc.docx.docx.PDF'.
>
> Simon.

I hear you... I once had a shareware app that I bought that the guy that
coded it had a weird way of saving progress by nesting folders all named
the same. I was watching a backup app once and thought, wtf, when I saw
\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\.
I am pretty good with computers actually but still can get caught
looking like a nob here and there. :-) I am one of the guys that was a
diehard VB6 Classic user and when I upgraded to .NET 2002 I was
instantly mad at the so called VB7 as it was nothing like the upgrade we
were expecting or wanting. I got the $20 update for .NET 2003 and looked
at it and stayed with VB6 Classic. I looked at Delphi, RealBASIC, and
PowerBasic, and realized I like VB. Now I thought I better get caught up
before Win8 starts messing with legacy apps. And as far as data base
programming, I am still a noob. I read all the thick Access books years
ago and spent a lot of time trying to learn but always reached a point
where I got totally confused when it came to design and primary and
foreign keys and relationship designer views. So here I go again. I
don't give up easy.
Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave

On 11/28/2011 4:59 PM, Simon Slavin wrote:

On 28 Nov 2011, at 10:44pm, Dave wrote:

On 11/28/2011 4:37 PM, Simon Slavin wrote:

Just to stress that the filename includes the bit after the '.'. You can have
any number of files with the same part before the '.' but different extensions.
To tell the operating system which one you want you must include the bit after
the '.'.

Actually, I knew that. Just having a bit of a multiple crash course...all at
once. I just recently built this pc and have been on XP until recently too. I
do some graphic stuff and have many same named pics with the various .jpg,
.bmp, .gif extensions.

My job involves dealing with lots of people who aren't good at computers and
the fact that, by default, the OS hides file extensions confuses the hell out
of them. I'm not taking a shot at Windows here: the Macintosh OS does the same
thing.

It also means you see files with names like 'paper.doc.docx.docx.PDF'.

Simon.

I hear you... I once had a shareware app that I bought that the guy that
coded it had a weird way of saving progress by nesting folders all named
the same. I was watching a backup app once and thought, wtf, when I saw
\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\.
I am pretty good with computers actually but still can get caught
looking like a nob here and there. :-) I am one of the guys that was a
diehard VB6 Classic user and when I upgraded to .NET 2002 I was
instantly mad at the so called VB7 as it was nothing like the upgrade we
were expecting or wanting. I got the $20 update for .NET 2003 and looked
at it and stayed with VB6 Classic. I looked at Delphi, RealBASIC, and
PowerBasic, and realized I like VB. Now I thought I better get caught up
before Win8 starts messing with legacy apps. And as far as data base
programming, I am still a noob. I read all the thick Access books years
ago and spent a lot of time trying to learn but always reached a point
where I got totally confused when it came to design and primary and
foreign keys and relationship designer views. So here I go again. I
don't give up easy.

70 matches

Mail list logo