Hi
adding an existing SQLite Database to a project.
In the Editor window I can see all the Tables and Columns of that DB and I’m able to add, edit and delete them.
But how can I browse the Database ? (like in the old DB window of RB 2012 r2.1)
thanks
Hi,
Had the same thought yesterday…
I downloaded http://sourceforge.net/projects/sqlitebrowser/ which works perfectly for me… and works across all platforms.
I’m sure there are other ways, but this will get you going…
Hope that helps
Marc
You can use FREE Valentina Studio - GUI Manager.
works fine with SQLite, mySQL and PostgreSQL databases, as well as with Valentina DB.
Set of features in this free edition beats easy all and any SQLite Managers, even commercials.
Read more here: http://www.valentina-db.com/en/valentina-studio-overview
OK there are alternatives
But a quick databrowser existed within the IDE and this is a big step backwards.
I found it very useful for quick check of the data. What sense does it make a tool to declare the tables and not the one to make the query and see the results?
I am using it for years, it’s not free but it’s an great All-In-One solution for creating, browsing, reporting and modelling Databases in MySQL, SQLlite, Postgre, MSSQL and Oracle:
And it’s cross platform for Mac, Linux and Win…
Sebastian, Tomas, can I invite you to play with Valentina Studio then?
We are very interested to hear comparison from developers that are used to other manager tools.
BTW, this forum seems do not allow to edit posts. In my above I did mistake in link. Here it is again:
http://www.valentina-db.com/en/valentina-studio-overview
and in the Mac App Store if somebody prefer.
I believe that this kind of feature was not excluded, just postponed a bit and will return.
The Valentina Studio offer from Ruslan is too. Take a look just in case. 
Thank you for your kind invitation and the Screenies of Valentia looks great (and it’s free of course) but it does not fit to me because I am mostly dealing with huge Enterprise mySQL, MSSQL and Orcale Databases using reporting and import/export tools on regular basis. But I saved a bookmark and will tell everybody whos searching like Hanspeter.
Hi Tomas,
You use reporting from Navicat? You work only on Windows? Just I remember, it have no reports on MAC OS X. Only on Windows. In contrast Valentina Studio have reports on all 3 OS. Reports of Navicat cannot be used in Xojo applications, and others, but Valentina Reports can be embedded.
Besides, Valentina Reports are part of Valentina Server, which can be used in same time as DB Server + Report Server. Again, it works native on 3 OS.
MSSQL – we will try add it, but as I understand, this will be possible only on Windows side…
Oracle also possible but after MSSQL.
I’m using SQLiteStudio http://sqlitestudio.pl/ which is free.
Maybe it would be nice to have a feature in Xojo preference where you could point to your own favorite database browser. This will also offload the Xojo staff for the time being.
Ruslan
Does your SQLite (et al) Browser support Foreign Keys with SQLite? Since that is new to SQLite it might be something to mention. 90% of the free browsers found online are out of date and no longer maintained so a lot of people will be looking for a new browser once they realize Foreign Keys are now supported on SQLite.
[quote=12796:@Jym Morton]Ruslan
Does your SQLite (et al) Browser support Foreign Keys with SQLite? Since that is new to SQLite it might be something to mention. 90% of the free browsers found online are out of date and no longer maintained so a lot of people will be looking for a new browser once they realize Foreign Keys are now supported on SQLite.[/quote]
Well SQLiteStudio http://sqlitestudio.pl/ support Foreign Keys and well maintained. And it is supported for all three platforms: Mac, Linux and Windows.
I have a similiar issue … what should I do if I need to have a record in the Database that my project will just update it ? It is my understanding that I also would need a Browser ? Any suggestions ?
Edgard, I don’t really understand what you mean. You need a browser mainly for creating and testing the database. Once your software is ‘in use’ there’s no need for a browser.
John, yes I know it does. I use it. That’s why I said 90% 
It’s one of the few that actually has someone maintaining it. He’s getting ready to roll out version 3
You can write a project that will read your (or any) SQLite db file.
It is not a waste of time since you will learn how to do … what you already have to do in your own db project.
Also, IMHO, writing right now an Import (TEXT --> DataBase file) and Export (DataBase file --> TEXT) Methods will help you far away from what you can think !
I wrote month ago a pdf to explain how to use the Real Studio all purpose DB editor. I do not checked xojo on this subject and I do not need to do that now. Once you will be able to Import / Export, you will be able to display the data (in a ListBox ?).
Also, one advantage of the Import / Export methods, is that you do not care anymore about the (sqlite or other) db file: you can generate it at will. If you enter manually data in the running project (or stand alone), you may have a trouble and loose data. Your camp chooses.