DB Browser for SQLite from which a few people have mentioned seems to have all the required functionality, it even has a small graphing pane which seems like overkill to me. I have just written the SQL lesson for the forthcoming Social Sciences curriculum, with several screenshots of the plugin and a tour of the facilities. I feel I will have to re-write it now, I could just leave out the details of the environment in use, but I would rather not. For example creating a table using the GUI is likely to be slightly different depending on choice. DBeaver which I have only just looked at would seem to have the advantage that it could be used with different database types, so presumably if anyone developed a lesson for MySQL or MariaDB the same interface could be used. On the downside (I'm speculating, as I haven' actually tried it) it could be more complex to use which wouldn't be good for people new to SQL in the first place. As we expect the attendees to install the necessary s/w in advance I don't think we can go for any complicated solutions.

I will try out the Social Sciences SQL lesson with DB Brower for SQLite and report back. Hi all- I just completed the Carpentries Instructor Training yesterday and used the 'SQL for Ecology: Basic Queries' as the episode for my teaching exercises. This issue with Firefox dropping support for the SQLite Manager plugin came up during my training. Today I tried both DBeaver and 'DB Browser for SQLite' on my Mac with the beginning of the SQL for Ecology lesson and concur with that the DB Browser seems like the way to go. I found DB Browser very intuitive and was quickly able to create a new SQLite DB and import the CSVs. It looks like it has the about the same functionality as the Firefox plugin and I think the interface is easier (and the error messages less scary for novices). Full disclosure: I used an early version DB Browser years ago, so I wasn't a complete novice with it.

DBeaver is clearly extremely powerful, and I might check it out to work with some of my MySQL DB. However, I found it quite frustrating to figure how to create a new SQLite database and import the CSV files. Both DBeaver and DB Browser seem to have problems with importing csv files. There are instruction for DBeaver ( a six point plan about half way down). There is also an outstanding request outlined here. The version I downloaded is 4.2.5 so I guess this will be the next release.

Apr 23, 2013  SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4, but work fine with PHP5. Maintenance Connection has a built a robust maintenance management software with feature-rich tools for the Manufacturing, Construction, Education industries, among others. Sqlite manager. Sqlite manager free download - SQLite Manager, SQLite Manager, Sqlite Manager, and many more programs. Business Software Productivity Software Utilities.

Asking for the ability to change the datatypes on the load is in keeping with what you would expect and is/was available with the Firefox plugin. Currently I cannot get it to let me change the datatypes even after I have imported the file (as all TEXT fields) - The properties screen won't let me change anything. DB Browser also doesn't give the option to change the datatypes on load, but at least it does allow me to modify the table structure afterwards. Another slight issue I have with DB Browser is that it seems to treat the whole session as a transaction, if you don't say you want to save the database at the end you lose all of your changes. What both have over the Firefox plugin though is the ability to save and load files of SQL and execute multiple statements at a time. For the SQL lesson in the Social Sciences curriculum I have decided to use DB Browser.

Perhaps not perfect, but straightforward to install and use. I have attached word documents covering the installation, launching and creating a table. All SQL runs as expected, although you need to be quite particular about including the ';' at the end of the statements. (even if you are just selecting a single statement to execute from the pane, if any of the previous statements are not terminated with a ';' it gets upset). Although several of us have moaned about having to change data-types after creating a table.

The modify table window does have the nice facility whereby as you change the options in the upper pane, you can see the DDL statement being modified in the lower pane. I see this as a great aid for teaching. As one of the DB Browser for SQLite developers, that sounds pretty awesome. 😄 Not sure if it's useful for your audience, but we've rewritten large parts of our CSV import code since our last major release. It now imports significantly faster (at least 3x as fast in most cases), and field data types are auto-detected on the way through. Duel masters card maker pch. Naturally though, you can still (manually) change the data types afterwards if you want.