SQLite Tutorial

[nextblain]

sqllite exact same as mysql command line?

[Jaynonymous1]

@nextblain - The SQL is very close. The built-in functions are different. Same name, different effect in few cases, same effect, different name in other cases. The "dot" commands (e.g. .quit, .schema, etc) are not there in the MySQL command line as far as I know.

[tarunpai]

how to install sqlite3?

[Jaynonymous1]

@tarunpai On Ubuntu, it is "sudo apt-get install sqlite3" or "sudo apt-get install sqlite". On windows, go to the sqlite download page, get the zip file for the sqlite shell, unzip it, and copy the utility to your windows system32 folder.

[eMGeeGFX]

If anyone wants to try out SQLite, it's available on the "Deathrow" remote access OpenVMS cluster.

You only need to define the following foreign DCL command and you're ready to go:

"$ SQLITE :== $DISK$USERS:[USERS.PAPO.BIN]SQ­LITE.EXE"

[Jaynonymous1]

@eMGeeGFX So does SQLite work on VAX/VMS?

[eMGeeGFX]

@Jaynonymous1, the GEIN:: system at "Deathrow" (currently available in the cluster) is an Alpha processor-based node. Or, did you mean if besides an Alpha port there's a VAX port as well? I haven't seen any of the latter, but I could probably build you a port most likely. (So you could use it on FAFNER:: or any other public access VAX node, or inside an emulator.)

[gilgomesp]

Very good, you was simple and efficient like @doubl3dge said.

[atma]

Thanks that was quite enlightening :-)

[CamiloSanchez1979]

How do u embed this in a web browser?

[Jaynonymous1]

@CamiloSanchez1979 Check out my video on SQLite and Javascript. In it you'll find the code for how to use it in a browser based on WebKit such as Chrome or Safari.

[projectptube]

quit striking the keys so hard. :)

[Jaynonymous1]

@projectptube Sorry about that. I'm and old-school guy who learned to type on a manual typewriter.

[waqas143nust]

well can you tell me how to use it with c language to extract data from file(database)

[DevonHartigan]

Awesome work! Helped me a lot.

[aissa336]

thank's for this tutoriaL

[doubl3dge]

Simple and efficient. Many Thanks.

[GeneTuberify]

thank you for this video tutorial

[c2designkitchen]

Cool!