Is there a Small Database Tutorial in AutoIt?

[Zohar]

Interesting.

When going to the Data tab, I see the hidden column you mentioned:

 

 

Aside it, is my ID column.

I changed ID's type from Number to Integer as you said,

and now the AutoIncrement checkbox was enabled so I changed it.

 

This raises an interesting issue:

As with all databases, when we want to choose the Type for a column, we usually have more than 1 option, for the same thing,

For example:

- Number, Integer, Int

- Char, NVarChar, NText, NChar, VarChar

etc..

 

So for each of these groups, which one is usually the best option?

Is there a list somewhere, recommending which one to choose from each group?

Or maybe, this "Recommended Types" list is affected by the programming language we use,

and if so, is there a recommended list for AutoIt?

Edited November 29, 2013 by Zohar

[jchd]

www.sqlite.org/datatype3.html

350% of all your questions are answered in gory details in the official SQLite documentation

I strongly advise you spend some time reading it. Since you already have good RDBMS background, you'll quickly find it easy to work with SQLite.

[Zohar]

OK, I will read it now

Thank you all

[jchd]

You can also google for the sqlite mailing list and its clones. Huge lot of information there too.

[Zohar]

Cool.

 

BTW you mentioned earlier that SQLite is used in various devices, even smartphones, etc.

Do you know what is the file in Android that contains the Calendar data and the Contacts data?

(I have Android v.4.2)

 

I assume it would we an SQLite file, and I want to see If I can open it with SQLite Expert..

Edited November 29, 2013 by Zohar

[jchd]

Googling "android calendar sqlite" brings a number of hits.

Of course you can browse any SQLite v3 database provided it has been created by SQLite v3. Note that a given DB may be encrypted, its schema can rely on proprietary extensions or even on proprietary modifications to the official SQLite trunk source code. Therefore it's best to refrain to modify a proprietary database with a general-purpose third-party manager. Trying to read the DB however is always harmless.

[Zohar]

Thank you jchd

I really like SQLite and SQLite Expert.

[jchd]

Good, welcome to the club. With AutoIt it makes a winning team!