Work with tables (empty them, rename them, etc).Read and modify data or information saved in a very simple way.but first, a screenshot:Īs I was saying, you can do basically the same thing: We can do almost the same as with the one before seen. SQLiteBrowserĪnother Qt application for the same. Although it lacks some other detail that at some point we might need, at least when we work with a lot of data. We can also edit data with a simple double click, all very, very simple. That is, I want to order the IDs from highest to lowest, if I click on the title ( user_id for example), he does not order it from lowest to highest or vice versa.īotton line, is a good Qt application to open this type of database and view its content. I said, simple or intuitive search engine this application does not have.Īlso, we cannot sort the columns by clicking on the title or heading of one of them. well, which they will not be able to without sweating a little. I can't get it to work for me, at least not in a simple way, the other thing that would remain would be to search directly for an SQL query, but those who are not used to this. I'm not so blind, I did see the search button but. well, something as simple as a search ( and that we use so much in other systems such as PHPMyAdmin) we cannot do it, it is missing when we have large amounts of data. we can work with tables, structures, etc: We can also modify data that is in fields or table cells.īut don't think you can do just that.Review the structure of the tables, as well as their information.The latest version (at least available in Arch repos) is from 2007, so we can't ask for much, with it we can: It is an application that does the right thing, neither more nor less. well, at this point in the post I think it was obvious, right? □ It's a Qt application that… guess what, it helps us to display and edit content from SQLite databases. Sudo aptitude install sqliteman sqlitebrowser In other distros like Debian or Ubuntu you already know: In ArchLinux I install both with the following command: in the repo of our distro we have available two graphic applications for this: SQLiteMan y SQLiteBrowser When we have the sqlite file and we need to see some data or simply modify it, How can we do it?. It told me that it needed to modify information from a SQLite database, but it refused to boot through Windows…. it was very early in the morning and I was still almost asleep lol. That is, a type of database that is being popular, its ability to store data without the need for a server ( as with MySQL or Postgre) is something without a doubt interesting.Ī few days ago an acquaintance of mine who lives in Spain ( works in some kind of company web positioning in Barcelona) told me that they were developing a small application to monitor SEO of certain sites, or something like that. On certain occasions we need to open a file of the type SQLite.
0 Comments
Leave a Reply. |