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. If you are
Windows-specific then there are also SQLite Expert
(www.sqliteexpert.com) and SQLitespeed (www.sqlc.rifin.co.za) for some
variety and more "Windowsy" interfaces, including some concept-teaching
sqlite scripts.
Any examples of a C,C++,C# or Python usage for sqllite.?
This question is hard to answer. The simple answer is "Yes, there are
examples." You probably would like to know where to find them though,
and the answer sadly is that Google is much better at that than anyone
on this forum. All we can accurately say is that SQLite is the most
widely used of all DB engines, so you should by implication find more
examples posted for it than for any other DB (and they all have plenty).
I would like sqllite on my raspberry pi 3 after I have gained
experience under Windows 10.
Sounds like fun!
Judging what the replies to questions, the very new beginners are left
a bit out in the cold.
Perhaps the documentation ought to cover the need of pure beginners.
Sorry you feel that way, we are in no way averse to beginners and indeed
welcome them with enthusiasm, we always love seeing new people get into
the wonderland that is Databasing and SQLite in particular.
That said, this forum essentially answers questions about SQLite,
whether about the C API, the SQL syntax used, the command-line tool etc.
Ironically, most questions we answer are about actual SQL and SQL
queries (whether specific to SQLite or SQL in general). Questions we ask
(and answers we give) usually deal with a specific subject and item. If
you say that you are new and want some general ideas on "How to use
SQLite..." - then that's a really wide question and some people study
courses lasting a long time to learn that kind of thing - It's not
something we can just answer in a few sentences.
You could read a book (http://www.sqlite.org/books.html), or follow
simple web instructions (such as: http://www.sqlite.org/quickstart.html)
on how to begin with SQLite, if you then try all that and perhaps get
stuck on a specific item or have a specific question, we'd be happy to
answer - but we can't really type up an SQL / SQLite manual for you.
(Though some of my answers feel sufficiently long). :)
We could also point you to some great learning resources on the web, but
they are already everywhere. This listing specifically includes Python
references:
http://charlesleifer.com/blog/my-list-of-python-and-sqlite-resources/
TLDR: The people here love beginners, but they offer problem-assistance
more than actual syllabus tutoring.
Hope this helps!
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
