What is Reddit's opinion of SQLiteStudio?

From 3.5 billion Reddit comments

sqlite is simple to work with, there are several user friendly interfaces like sqlite studio

I would definitely not recommend Microsoft Access, it's expensive, it's overly complicated and you learn very little of what databases really are about. And it doesn't easily expand to the web - (and that's only if you plan on using windows server for your web facing endeavors).

If you want a really good database with lots of growing potential you should go straight for postgres - it's the best free database and has excellent documentation.

Personally I find hands on the best approach.

SQLite is a flat file that simulates an SQL database without having to have a RDBMS installed.

I use it with Python3 and also have a GUI (free, open source) called SQLite Studio (http://sqlitestudio.pl/) for inspecting the database directly and also DB creation & queries via SQL.

If you combine Python and SQLite with PRAW (Python Reddit API Wrapper) you can generate database content from reddit itself too. I have a modbot app that I'm working on that does just that - it pulls info off reddit for a sub I mod, stores it in a local SQLite database along with the status of the post with regards to moderation tasks I want it to perform. I can query the database via SQLite Studio to help with debuging my code and to help create SQL statements I then insert into my Python code as I implement other features.

Muy buen aporte. Prefiero bajar el archivo SQLite directamente de https://github.com/Zequez/telegramas-balotaje-argentina-2015/blob/master/telegramas.sqlite3 y usar SQLite Studio para hacer queries.

WTF is up with the replies in this thread? Shame on you folks.

Yes, SQLite is what you want to use. And it's an additional plus that Python supports it out of the box.

I would spend a lot of time thinking about what you need your database to record. It's not easy to add columns on the fly to database, but it is easy to insert new records - which is what I think you meant.

I would start of with one table. Call it tblPlayers, in this table have the following columns: fldPlayerName, fldElo. Here is the tricky part, does that website give you are unique reference for each player in your brackets?

Cause when the ELO changes, you'll need to update that ELO for that player. But looking up via player-name is bad practice, it is better to use something completely unique.

It's hard to design your DB in Python, so I'd suggest something like <strong>SQLiteStudio</strong> to help you to design the DB backend. Then you can interact with it via Python.

Edit* Spelling

It looks like http://sqliteadmin.orbmu2k.de which AFAIK doesn't run on OS X. There are a number of apps that work on OSX, all of them will do what you want.

here are two that are free:

https://github.com/sqlitebrowser/sqlitebrowser

http://sqlitestudio.pl

For the hard core:

Sometimes the omnibox can have some really ridiculous predictions, and you can't delete those (see chrome://predictors/ for a run-down ).

If it's really annoying, there is a way...

• Find the Network Action Predictor file in C:\Users\<Username>\AppData\Local\Google\Chrome\User Data\Default. It's an SQLite database.

• Use something like SQLiteStudio to open and edit it.