Showing posts with label sqlite. Show all posts
Showing posts with label sqlite. Show all posts

Monday, September 29, 2014

Hearthstone SQLite database

In the past two weeks I have been doing something interesting, I was developing a Hearthstone database in SQLite 3.7.9. I built it mainly to practice some SQLite programming.
Some guy managed to collect all information from some internal Hearthstone file and put it on this website: http://hearthstonejson.com/
I used a php script which I built to export the data from the json file to my SQLite database.
You can download the comple sql file from here: https://dl.dropboxusercontent.com/u/66845602/hearthstone/sqlhearthstone.sql

or you can restore the complete database into you sqlite3 from this file: https://dl.dropboxusercontent.com/u/66845602/hearthstone/sqlhearthstone.db

I have some other plans to do next, so maybe there will be hearthstone db version 2.0. I don't know.

I am not affiliated with Hearthstone or Blizzard in any way.

All information in the sql file and the db file belongs to Hearthstone © Heroes of Warcraft and Blizzard © Entertainment developers.

If you have some suggestions I would gladly hear them.

Wednesday, February 19, 2014

Links: Learn basic and advanced SQL

I searched the net for some good online quizes about SQL

Here are some links I found:

A basic quiz about SQL from W3Schools
http://www.w3schools.com/quiztest/quiztest.asp?qtest=SQL

Basic SQL quiz:
http://www.sqlquiz.com/sql-quiz.php

SQL Guide with onsite SQL console
http://sqlzoo.net/wiki/Main_Page

My personal best are:


Beautiful Javascript quiz on NetTuts:
http://code.tutsplus.com/articles/nettuts-quiz-11-do-you-know-sql--net-24439

Desktop application for practicing SQL. Uses SQLite and 3D galaxy with stars as data.
http://sourceforge.net/projects/galaxql/



More thorough website covering basic aswell as advanced database concepts:
http://www.indiabix.com/database/questions-and-answers/

Enables you 10/20 or 25 question timed or casual quiz:
http://withoutbook.com/OnlineTestStart.php?quizId=15