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
