I used DB Browser for SQLite to import my CSV file as the table match_basic. DB Browser for SQLite is an open source tool to "create, design, and edit database files compatible with SQLite." It doesn't play super well with my computer's high-dpi screen but it's still usable.
#Sqlite 3 windows 7 update#
Some people may actually prefer to use the command line to create, manage, and update their databases but I am definitely not hardcore enough for that.
You don't even need to reboot in Windows 10! (It's the little things in life) Installing DB Browser for SQLite
Type in your directory (in my case C:\\SQLite3). Select either the Path variable under user or system variables. Click on 'Environment Variables' if you need to. Click 'Edit environment variables for your account' (or 'Edit the system environment variables'). In windows 10, it's pretty easy to add a folder to your PATH variable. I followed the basic ideas at, created a C:\\SQLite3 folder and stuck the all the dll and exe files inside it. Worst case, I can always migrate it to MySQL, like the Ghost blogging platform did awhile back. I'm sure I will probably regret using SQLite one day, but for now it should work fine. I wanted something fast and have no need for multi-user authentication. For sharing purposes, I also like being able to just share one file, which is just how SQLite works. This means I wanted a server-less database, which SQLite is. While I actually do run a FreeNAS server at home, I purposefully did not open up any SSH or FTP access to outside outside my home network. I am not all that familiar with any of the three major open source databases (SQLite, MySQL/MariaDB, and PostgreSQL). I also happen to be learning SQL at work, so this seems like the normal thing to do. While a CSV is pretty easy to write to, I wanted to be able to store information in a way that would scale up as time went on. To be honest, that worked perfectly fine although I have been hoping to do some more advanced analysis, particularly looking into rating players. I recently wrote a post on rating teams in Heroes of the Storm and used a regular CSV to store all the data for my ratings.
0 kommentar(er)
