Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 21 May 2014, at 9:36am, Tim Streater wrote: > On 21 May 2014 at 00:17, RSmith wrote: > >> On 2014/05/20 23:37, Tim Streater wrote: >>> Sorry, should have said I'm on OS X Mavericks 10.9.3. >> >> We know... no other OS would report CPU usage as 400%... :) > > :-) > > Well, to be fair, I don't know what OS X was reporting. For those not in on the joke, a fully-loaded four-core Macintosh can report that it is working at 400% capacity. This allows you to compare efficiency with other Macs which have different numbers of cores without having to double or halve numbers. But it does look weird when you see CPU > 100%. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 2014-05-21 08:36, Tim Streater wrote: Of course, it might be lying in its teeth for all I know, but the fan did wind up. Nah, it wasn't lying. Qt is a huge amount of code, and Homebrew uses all available processor cores to compile it. And it still take ages. ;) + Justin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 21 May 2014 at 00:17, RSmith wrote: > On 2014/05/20 23:37, Tim Streater wrote: >> Sorry, should have said I'm on OS X Mavericks 10.9.3. > > We know... no other OS would report CPU usage as 400%... :) :-) Well, to be fair, I don't know what OS X was reporting. I have iStat Menus installed, which shoves a lot of useful stuff in the menu bar. This includes thermometers for the four cores, as well as sensor info (fan speed and CPU temp in this case). Of course, it might be lying in its teeth for all I know, but the fan did wind up. -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
As compiling under windows is really a pain I try to avoid it as much as possible :) But it should be doable with qmake or cmake with a little tweaking. But needed libs are Qt and sqlite. Before I switched to cross-compiling I had an msys environment, but with some effort it should also work with VS. Cheers Rene On Tue, May 20, 2014 at 7:25 PM, wrote: > On 2014-05-20 16:35, big stone wrote: > >> Hi Justin, >> >> What are the necessary steps to rebuild SQLite Database Browser from >> source, on a windows 7 PC ? >> >> (I have no Qt experience, so not sure of what to download ) >> > > Good question. We should write up some instructions for that. :) > > Rene or Martin (both CC'd) are the C++ guys, so may be able to > help. > > I *think* Rene is generating the Windows binaries by cross > compiling from Linux. The binaries seem to work pretty well, > so (thus far) it's been an ok approach. ;) > > I tried quickly myself about 2 weeks ago, but wasn't sure which > bits of what to download (eg msys? mingwin? sqlite-libs?) so > didn't have any success. Kept with OSX Homebrew instead at > the time. ;) > > Anyway, hopefully Rene or Martin can help. :) > > Regards and best wishes, > > Justin Clift > -- Rene Peinthor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 2014-05-20 21:35, Tim Streater wrote:
I followed the instructions at the github URL, and was able to build
sqlitebrowser. Couple of points:
1) Warn folks not to have a single-quote (') in their path, it causes
the make of sqlitebrowser to fail. I moved the folder elsewhere and
redid the qmake, make, steps and it completed.
Thanks, that's good info. Created a bug report for it:
https://github.com/sqlitebrowser/sqlitebrowser/issues/10
... and updated GitHub+website with the info (including working on OSX
10.9).
2) It took 57 minutes on a 2011 2.3GHz Core i5 Mini to build qt
(whatever that may be) although perhaps a bit of that might have been
it waiting for me to agree the licence (I was out of the room). That
wound the CPU up to 400%, the fan to 6000rpm, and the core temp to
90C. Still, it seems fine.
Yeah, Qt is huge. ;) It's a (generally) very high quality cross
platform window library. There are smaller alternatives, but the
end result from them (in my opinion) just isn't as good.
I also had to install brew, but that was quite quick.
Now I'll have to figure out how to use it.
Hopefully it's mostly straight forward. If you encounter bugs
or have suggestions, please feel free to open an Issue on GitHub
(preferred) or email. :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
Well, Apple uses special CPU compression technology to get more work done in the same amount of time... ;) On Tue, May 20, 2014 at 5:17 PM, RSmith wrote: > > On 2014/05/20 23:37, Tim Streater wrote: > >> Sorry, should have said I'm on OS X Mavericks 10.9.3. >> > > We know... no other OS would report CPU usage as 400%... :) > > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 2014/05/20 23:37, Tim Streater wrote: Sorry, should have said I'm on OS X Mavericks 10.9.3. We know... no other OS would report CPU usage as 400%... :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 20 May 2014 at 14:11, jus...@postgresql.org wrote: > http://sqlitebrowser.org > https://github.com/sqlitebrowser/sqlitebrowser Sorry, should have said I'm on OS X Mavericks 10.9.3. -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 20 May 2014 at 14:11, jus...@postgresql.org wrote:
> Hi all,
>
> Just a small heads up. The old SQLite Database
> Browser project on SourceForge is officially
> on GitHub as of today, and we've made a new
> release (v3.1) as well. New website too (using
> GitHub pages):
>
> http://sqlitebrowser.org
> https://github.com/sqlitebrowser/sqlitebrowser
I followed the instructions at the github URL, and was able to build
sqlitebrowser. Couple of points:
1) Warn folks not to have a single-quote (') in their path, it causes the make
of sqlitebrowser to fail. I moved the folder elsewhere and redid the qmake,
make, steps and it completed.
2) It took 57 minutes on a 2011 2.3GHz Core i5 Mini to build qt (whatever that
may be) although perhaps a bit of that might have been it waiting for me to
agree the licence (I was out of the room). That wound the CPU up to 400%, the
fan to 6000rpm, and the core temp to 90C. Still, it seems fine.
I also had to install brew, but that was quite quick.
Now I'll have to figure out how to use it.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
On 2014-05-20 16:35, big stone wrote: Hi Justin, What are the necessary steps to rebuild SQLite Database Browser from source, on a windows 7 PC ? (I have no Qt experience, so not sure of what to download ) Good question. We should write up some instructions for that. :) Rene or Martin (both CC'd) are the C++ guys, so may be able to help. I *think* Rene is generating the Windows binaries by cross compiling from Linux. The binaries seem to work pretty well, so (thus far) it's been an ok approach. ;) I tried quickly myself about 2 weeks ago, but wasn't sure which bits of what to download (eg msys? mingwin? sqlite-libs?) so didn't have any success. Kept with OSX Homebrew instead at the time. ;) Anyway, hopefully Rene or Martin can help. :) Regards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Database Browser officially moved to GitHub
Hi Justin, What are the necessary steps to rebuild SQLite Database Browser from source, on a windows 7 PC ? (I have no Qt experience, so not sure of what to download ) Regards, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Database Browser officially moved to GitHub
Hi all, Just a small heads up. The old SQLite Database Browser project on SourceForge is officially on GitHub as of today, and we've made a new release (v3.1) as well. New website too (using GitHub pages): http://sqlitebrowser.org https://github.com/sqlitebrowser/sqlitebrowser Hope that's useful for people. :) Regards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
