rp- / sqlitebrowser Goto Github PK

View Code? Open in Web Editor NEW

This project forked from daffodil/sqlitebrowser

35.0 35.0 8.0 7.44 MB

deprecated repo, check website

Home Page: https://github.com/sqlitebrowser/sqlitebrowser

License: Other

C++ 99.49% C 0.01% GAP 0.44% Shell 0.02% Python 0.05%

sqlitebrowser's People

Contributors

Stargazers

Watchers

Forkers

slopjong mmankarious takluyver oysteinkrog stretchtiberius suxinde2009 curtisyen74 arcticwaters

sqlitebrowser's Issues

Cannot associate with file types in Windows

Great updates to what was already a good program! Thanks to all.

I am using Sqlitebrowser 3.0.2 on my Windows Vista machine, it works well. However, I cannot seem to associate file types to automatically open in the program. For example, I am trying to set .db files to open automatically. When I choose the sqlitebrowser.exe installed on my computer, it just goes back to the program selection screen without choosing it. I tried other extensions with the same result. No other program is already associated with the .db extension. Is this an issue with the program?

Grammar fails on foreign key constraints

Our grammar parser fails at least on some foreign key constraints.
This can be reproduced using, for example, this create statement

CREATE TABLE grammar_test(id, test, FOREIGN KEY(test) REFERENCES other_table);

and then adding a new record to this table using the button in the browse tab. This results in a segfault in sqlitetypes.cpp, l. 300 and the following error message:

line 1:45: unexpected token: KEY

Query regarding Windows executable size

It seems we have had a jump in file sizes, my Windows 7 box suggests the following:

sqlitebrowser.exe (3.0.0) 12,711,537 bytes
sqlitebrowser.exe (3.0.1) 30,129,436 bytes
sqlitebrowser.exe (3.0.2) 30,210,968 bytes

I am not sure what changed but all three versions work fine as standalone executables. If there is an option for smaller executables that would seem good. However there might be a good explanation, hence why I am curious. Sorry for being curious!

Execute SQL: previous results not removed

If I use the Execute SQL tab to execute a query that returns no results then the previous results are not removed, this is confusing and it gets me everytime!

open a database in SQLiteBrowser (3.0.1)
switch to the Execute SQL tab
execute a query that returns results
observe the results and the message, eg 27 Rows returned from :select.... (took 2ms)
execute another query that returns 0 results
the previous queries results table is still displayed
the message is removed

I would like to see the results table cleared and hidden and the message box saying something like "0 Rows returned from: select... (took 5ms)". This would really help me, please.

New compilation errors on OSX

Just tried compiling this again as per request by @MKleusberg

It's barfing a little way in with:

clang++ -c -pipe -O2 -arch x86_64 -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I../libs/antlr-2.7.7 -I../libs/qhexedit -Irelease -I.ui -F/usr/local/Cellar/qt/4.8.4/lib -o release/AboutDialog.o AboutDialog.cpp
AboutDialog.cpp:3:10: fatal error: 'gen_version.h' file not found
#include "gen_version.h"

Reckon you can fix that? 😄

File associatians not working on MacOS X

According to Justin in PR #24 setting SQLiteBrowser as the default application for SQLite databases and then opening them by double-clicking doesn't work. The application starts but the file is not opened.
Some Google research revealed that MacOS X starts an application without any arguments to then send a signal (an "Apple event") to it, asking it to open the file. We have some old and broken Carbon code in main.cpp to do this which, however, is currently disabled. We could fix it but as far as I know Carbon only supports 32bit apps so we might want to replace it by some Cocoa implementation which apperently requires an Objective-C file... Any ideas on how we can fix this easily?

Main source:
http://stackoverflow.com/questions/7892669/getting-appleevents-in-qt-cocoa

Name of Column lost when adding any Column after the 11th

So if I enter the column name in the table dialog, eg. AnotherColumn, it is not stored but replaced by the original, "Fieldxx", when I exit the table dialog after clicking OK.

This happens when

I create a new table using the UI and add more than 11 columns.
I create a new table using create table sql then modify the table - if it has more than 11 columns the names of new fields added are replaced with "Fieldxx". All original column names remain as they were, even if the table had more than 11 columns when opened for modification.
Edit an existing table and column count rises above 11 columns.

I've only recently started using sqlite and sqlite browser so if I've missed something apologies for the post. I've rtfm and see no constraint imposed by sqlite/sqlitebrowser. I've also done the usual - tried with a new database, ensured changes are written, compacted, closed/opened etc, no joy.

Also, it is not possible to delete these "Fieldxx" columns once they've been created (whether changes have been written to DB or not) but the error message isn't clear to me -

"renameColumn: creating new table failed, DB says:''0'': syntax error"

I have a bunch of default values set, they were (integer) zero, but sqlbrowser changed that to '0' and then to ''0'' (4 single quotes, not double quotes) but that is perhaps another issue. [edit] after more testing this does appear to be another issue - whereby existing default values are wrapped in single quotes even when the value has them.

Steve

Browse Data Find button fails on integer search term

I just tried 'sqlitebrowser_200_b1_win.zip' on an XP machine. Immediately found a bug in Find button. What I saw matches the title of Source Forge bug #36 -- The 'Floating Find Window' evaluates only the first character of the search string. -- That bug is closed as unreproducable.

I tried the program to look at the contents of an SQLite 3 DB made from downloading contents of a Yahoo Group. One table is Messages, it has a field 'person' which is an integer. It came from another table that gives an integer ID for a person's name.

In the 'Browse Data' tab I opened the Find button. I entered a search for 'person = 932'. It returned a list of records with 'person = 9'. Tried find 'person = 10' got person = 1. There are similar issues with >, >=, etc. but searches for text fields seems to work OK.

After frustration, thinking I must be doing something wrong, this is too blatant... I downloaded older 'sqlitebrowser-1.3-win.zip' and using that for the same find on the same database table works as expected... 'person = 932' returns records where person = 932.

Close Database does not clear UI

If you open a database in SQLite Database Browser 3.0.2 and the close it via the file menu then the complete structure remains on the "Database Structure" tab, it would be much clearer if this was cleaned up and empty. Also on the "Browse Data" tab the "0 to n of n" remains at the bottom".

This happens every time for me in 3.0.2 on Windows, if you could find time to tidy this up that would be much appreciated. Thanks!

Need your email addresses

@rp- @MKleusberg Would you guys be ok to email me (justin AT gluster DOT org)?

Would like to discuss some interesting stuff, and can't easily find your emails. 😄
(so yeah, this is me being lazy)

Compiling fails on Mac OS X 10.9

Unfortunately I couldn't compile sqlbrowser when following your description in the readme. Make fails on my MacBook Air with Mac OS X 10.9.

The output of make ends with:
Linking CXX executable sqlitebrowser Undefined symbols for architecture x86_64: "_sqlite3_enable_load_extension", referenced from: DBBrowserDB::open(QString const&) in sqlitedb.cpp.o DBBrowserDB::create(QString const&) in sqlitedb.cpp.o "_sqlite3_load_extension", referenced from: DBBrowserDB::loadExtension(QString const&) in sqlitedb.cpp.o ld: symbol(s) not found for architecture x86_64 clang: error: linker command failed with exit code 1 (use -v to see invocation) make[2]: *** [sqlitebrowser] Error 1 make[1]: *** [CMakeFiles/sqlitebrowser.dir/all] Error 2 make: *** [all] Error 2

$ clang --version Apple LLVM version 5.0 (clang-500.2.79) (based on LLVM 3.3svn) Target: x86_64-apple-darwin13.0.0 Thread model: posix

Is there anything else I can provide for you to solve the issue?

keep selected table for browse data on tab switch

if you switch the tab to 'Database Structure' or 'Execute SQL' the current selected table is reset.

make browse data read only

currently clicking a cell in the browse data, starts edit mode on this cell.
inline editing should be disabled.

Export to CSV user interface suggestions

I have used Export to CSV a few times now and each time it catches me out, so here are some comments around potential improvements:

When I select Export to CSV it defaults to the first Table, sorted alphabetically. However the list of tables on the Data Structure tab is not alphabetical, so can I make the following suggestions:

the table list in Data Structure, along with the other lists, like Indices is sorted alphabetically
when using Export to CSV from the file menu it either defaults to the first table or the selected table, if one has been selected in Data Structure
on the Browse Data tab, Export to CSV should default to the current table
in Data Structure, it would be great to have Export to CSV on the table's right click context menu, that is where I keep looking for it!
it would be clearer if the table name was a list not a drop down combo box, it would make it clearer that you need to select a table

I appreciate this is several issues in one and that not everyone will like my ideas. I am trying to give some constructive feedback to help improve.

Please be encouraged, SQLiteBrowser is a great tool, so please keep up the great work!

import database from sql is not working

to reproduce:

export a simple sqlite db with File->Export->Database to SQL file...
close current db
import the exported file again and save as new database
-->
Error importing data: Error in statement #2: object name reserved for internal use: sqlite_sequence.
Aborting execution.

Sort Table List

It would be nice if the Table list on the Browse Data tab was sorted as I have lots of tables to search through to select what I need.

Good work on keeping this project running!

Hidden files/directories not being shown (on OSX)

It would be really useful to display hidden files/dirs in the Open Database dialog. 😄

At present the "Open Database" dialog isn't showing hidden files/directories. (on OSX, haven't tried Windows)

This is annoying (daily) as it means I have to change files/dirs so they can be seen, open them while being used, then change them back afterwards. (near daily)

Hopefully it's a simple fix. Note - not sure, but maybe this is related?

https://qt.gitorious.org/qt/qt-for-tizen-packaging-qtdeclarative/commit/3d96c688a919c3ebc0ea3822e59bbc728c68eb95

browse data: clicking a table header should change sort order

when clicking a browse data table header change the sort order according to the column

SqliteTableModel: Problematic way of counting rows and limiting the result range

We have two problems in our SqliteTableModel class one of which is caused by simply taking the SQL query and putting it into a COUNT query. This obviously fails for some statements like this one:

SELECT * FROM table -- comment

which leads to this being executed and no results being shown:

SELECT COUNT(*) FROM (SELECT * FROM table -- comment);

Also, if a query has already been executed before that the entire application will crash.

The other bug lies in the fetchData method where a "LIMIT x, y" is appended to the query. Here again problems arise when the statement to be executed ends with a comment. But the method also fails when the SQL comes with its own LIMIT part. In case such an SQL statement ends with a semicolon the resulting code looks like this:

SELECT * FROM table LIMIT 0,10; LIMIT 0, 50000;

Sure, this is invalid SQL but doesn't cause too much harm as the first statement is perfectly fine and gives the expected results while the second one just fails silently. However, if it doesn't have a trailing semicolon this is executed:

SELECT * FROM table LIMIT 0,10 LIMIT 0, 50000;

This not only doesn't return any data but also puts the application in an endless loop of trying to execute this statement over and over again.

I will try to find some workarounds for these bugs in the next days but any help is appreciated. And in the long run it might be necessary to write a grammar parser for SELECT statements.

Preferences ➡ SQL window not large enough on OSX

On (at least) OSX 10.7.5, the default size for the Preferences window isn't big enough to
fit the SQL tab contents easily.

Ideally the default size should be big enough that the SQL tab contents display properly without manual resizing. (or perhaps the dialog automatically resizes when changing to the SQL tab?)

Filters no longer work in 3.0.3

Using the 3.0.3 release on Windows Vista, the filters no longer appear to work on the "Browse Data" tab. Previously, typing anything in a column would limit the result to exact matches of that column. Now, nothing happens. Using TAB, ENTER, or clicking off of the field does not change anything either.

Compile failure on OSX 10.7

Just tried compiling on OSX 10.7 without success.

It's failing with a bizarre error. Seems like Qt wants to compile for PPC architecture, although this is an Intel x86_64 CPU.

Any idea how to tell Qt to not compile for PPC?

Tried setting "CONFIG = x86_64" in sqlitedbbrowser.pro (after some investigation via Googling), but that made no difference.

Full output below:

$ make
cd libs/antlr-2.7.7/ && /usr/local/bin/qmake /DATA/git_repos/sqlitebrowser/libs/antlr-2.7.7/antlr.pro -o Makefile.antlr
cd libs/antlr-2.7.7/ && make -f Makefile.antlr 
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TreeParser.o src/TreeParser.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TokenStreamSelector.o src/TokenStreamSelector.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TokenStreamRewriteEngine.o src/TokenStreamRewriteEngine.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TokenStreamHiddenTokenFilter.o src/TokenStreamHiddenTokenFilter.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TokenStreamBasicFilter.o src/TokenStreamBasicFilter.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TokenRefCount.o src/TokenRefCount.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/TokenBuffer.o src/TokenBuffer.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/Token.o src/Token.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/String.o src/String.cpp
src/String.cpp:41:19: warning: format specifies type 'unsigned int' but the argument has type 'size_t' (aka 'unsigned long') [-Wformat]
        sprintf(tmp,"%u",rhs);
                     ~~  ^~~
                     %lu
1 warning generated.
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/RecognitionException.o src/RecognitionException.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/Parser.o src/Parser.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/NoViableAltForCharException.o src/NoViableAltForCharException.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/NoViableAltException.o src/NoViableAltException.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/MismatchedTokenException.o src/MismatchedTokenException.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/MismatchedCharException.o src/MismatchedCharException.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/LLkParser.o src/LLkParser.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/InputBuffer.o src/InputBuffer.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/CommonToken.o src/CommonToken.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/CommonHiddenStreamToken.o src/CommonHiddenStreamToken.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/CommonASTWithHiddenTokens.o src/CommonASTWithHiddenTokens.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/CommonAST.o src/CommonAST.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/CharScanner.o src/CharScanner.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/CharBuffer.o src/CharBuffer.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/BitSet.o src/BitSet.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/BaseAST.o src/BaseAST.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/ASTRefCount.o src/ASTRefCount.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/ASTNULLType.o src/ASTNULLType.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/ASTFactory.o src/ASTFactory.cpp
clang++ -c -pipe -O2 -fPIC  -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I. -o .obj/ANTLRUtil.o src/ANTLRUtil.cpp
rm -f libantlr.a
ar cq libantlr.a .obj/TreeParser.o .obj/TokenStreamSelector.o .obj/TokenStreamRewriteEngine.o .obj/TokenStreamHiddenTokenFilter.o .obj/TokenStreamBasicFilter.o .obj/TokenRefCount.o .obj/TokenBuffer.o .obj/Token.o .obj/String.o .obj/RecognitionException.o .obj/Parser.o .obj/NoViableAltForCharException.o .obj/NoViableAltException.o .obj/MismatchedTokenException.o .obj/MismatchedCharException.o .obj/LLkParser.o .obj/InputBuffer.o .obj/CommonToken.o .obj/CommonHiddenStreamToken.o .obj/CommonASTWithHiddenTokens.o .obj/CommonAST.o .obj/CharScanner.o .obj/CharBuffer.o .obj/BitSet.o .obj/BaseAST.o .obj/ASTRefCount.o .obj/ASTNULLType.o .obj/ASTFactory.o .obj/ANTLRUtil.o
ranlib -s libantlr.a
cd libs/qhexedit/ && /usr/local/bin/qmake /DATA/git_repos/sqlitebrowser/libs/qhexedit/qhexedit.pro -o Makefile
cd libs/qhexedit/ && make -f Makefile 
clang++ -c -pipe -O2 -arch x86_64 -fPIC -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -o commands.o src/commands.cpp
clang++ -c -pipe -O2 -arch x86_64 -fPIC -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -o qhexedit.o src/qhexedit.cpp
In file included from src/qhexedit.cpp:1:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/QtGui:4:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/qaccessible.h:52:
In file included from /usr/local/Cellar/qt/4.8.4/include/QtGui/qevent.h:52:
/usr/local/Cellar/qt/4.8.4/include/QtGui/qmime.h:119:10: warning: private field 'type' is not used [-Wunused-private-field]
    char type;
         ^
1 warning generated.
clang++ -c -pipe -O2 -arch x86_64 -fPIC -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -o qhexedit_p.o src/qhexedit_p.cpp
In file included from src/qhexedit_p.cpp:1:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/QtGui:4:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/qaccessible.h:52:
In file included from /usr/local/Cellar/qt/4.8.4/include/QtGui/qevent.h:52:
/usr/local/Cellar/qt/4.8.4/include/QtGui/qmime.h:119:10: warning: private field 'type' is not used [-Wunused-private-field]
    char type;
         ^
1 warning generated.
clang++ -c -pipe -O2 -arch x86_64 -fPIC -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -o xbytearray.o src/xbytearray.cpp
/usr/local/Cellar/qt/4.8.4/bin/moc -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -D__APPLE__ -D__GNUC__ src/qhexedit.h -o .moc/moc_qhexedit.cpp
clang++ -c -pipe -O2 -arch x86_64 -fPIC -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -o moc_qhexedit.o .moc/moc_qhexedit.cpp
In file included from .moc/moc_qhexedit.cpp:10:
In file included from .moc/../src/qhexedit.h:4:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/QtGui:4:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/qaccessible.h:52:
In file included from /usr/local/Cellar/qt/4.8.4/include/QtGui/qevent.h:52:
/usr/local/Cellar/qt/4.8.4/include/QtGui/qmime.h:119:10: warning: private field 'type' is not used [-Wunused-private-field]
    char type;
         ^
1 warning generated.
/usr/local/Cellar/qt/4.8.4/bin/moc -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -D__APPLE__ -D__GNUC__ src/qhexedit_p.h -o .moc/moc_qhexedit_p.cpp
clang++ -c -pipe -O2 -arch x86_64 -fPIC -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I.moc -F/usr/local/Cellar/qt/4.8.4/lib -o moc_qhexedit_p.o .moc/moc_qhexedit_p.cpp
In file included from .moc/moc_qhexedit_p.cpp:10:
In file included from .moc/../src/qhexedit_p.h:7:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/QtGui:4:
In file included from /usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers/qaccessible.h:52:
In file included from /usr/local/Cellar/qt/4.8.4/include/QtGui/qevent.h:52:
/usr/local/Cellar/qt/4.8.4/include/QtGui/qmime.h:119:10: warning: private field 'type' is not used [-Wunused-private-field]
    char type;
         ^
1 warning generated.
rm -f libqhexedit.a
ar cq libqhexedit.a commands.o qhexedit.o qhexedit_p.o xbytearray.o moc_qhexedit.o moc_qhexedit_p.o
ranlib -s libqhexedit.a
cd src/ && /usr/local/bin/qmake /DATA/git_repos/sqlitebrowser/src/src.pro -o Makefile
cd src/ && make -f Makefile 
/usr/local/Cellar/qt/4.8.4/bin/uic MainWindow.ui -o .ui/ui_MainWindow.h
/usr/local/Cellar/qt/4.8.4/bin/uic CreateIndexDialog.ui -o .ui/ui_CreateIndexDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic AboutDialog.ui -o .ui/ui_AboutDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic EditTableDialog.ui -o .ui/ui_EditTableDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic PreferencesDialog.ui -o .ui/ui_PreferencesDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic FindDialog.ui -o .ui/ui_FindDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic EditDialog.ui -o .ui/ui_EditDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic ExportCsvDialog.ui -o .ui/ui_ExportCsvDialog.h
/usr/local/Cellar/qt/4.8.4/bin/uic ImportCsvDialog.ui -o .ui/ui_ImportCsvDialog.h
clang++ -c -pipe -DAPP_VERSION=\"`cd /DATA/git_repos/sqlitebrowser/src;git log -n1 --format=%h_git`\" -O2 -arch x86_64 -arch ppc -arch i386 -Wall -W -DQT_NO_DEBUG -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/usr/local/Cellar/qt/4.8.4/mkspecs/unsupported/macx-clang -I. -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtCore.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/lib/QtGui.framework/Versions/4/Headers -I/usr/local/Cellar/qt/4.8.4/include -I../libs/antlr-2.7.7 -I../libs/qhexedit -I.moc -I.ui -F/usr/local/Cellar/qt/4.8.4/lib -o .obj/sqlitedb.o sqlitedb.cpp
clang: warning: not using the clang compiler for the 'powerpc' architecture
sqlitedb.cpp:367:24: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
                qDebug(lastErrorMessage.toStdString().c_str());
                       ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:375:20: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
            qDebug(lastErrorMessage.toStdString().c_str());
                   ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:529:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(lastErrorMessage.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:537:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(lastErrorMessage.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:558:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(lastErrorMessage.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:568:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(lastErrorMessage.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:577:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(lastErrorMessage.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:593:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(lastErrorMessage.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:707:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(error.toStdString().c_str());
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:962:24: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
                qDebug(QObject::tr("unknown object type %1").arg(val1).toStdString().c_str());
                       ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:966:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(QObject::tr("could not get list of db objects: %1, %2").
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:1106:20: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
            qDebug(QObject::tr("didn't receive any output from pragma %1").arg(pragma).toStdString().c_str());
                   ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:1110:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(QObject::tr("could not execute pragma command: %1, %2").
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sqlitedb.cpp:1127:16: warning: format string is not a string literal (potentially insecure) [-Wformat-security]
        qDebug(QObject::tr("Error setting pragma %1 to %2: %3").
               ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
14 warnings generated.
llvm-g++-4.2: error trying to exec '/usr/bin/../llvm-gcc-4.2/bin/powerpc-apple-darwin11-llvm-g++-4.2': execvp: No such file or directory
clang: error: gcc frontend command failed with exit code 255 (use -v to see invocation)
make[1]: *** [.obj/sqlitedb.o] Error 255
make: *** [sub-src-make_default] Error 2

Query ending with comments causes a crash

If I input the following SQL statement it causes SQLiteBrowser 3.0.2 to crash

select count(*) from Products
--comment

I have tried -- comments and /**/ comments in many other locations in relation to my query and they all seem to work fine. However it would be great if you could allow -- comments on the last line, or at least not crash! Thanks

copy paste from sql output only works if you select 2 or more cells

I just noticed this annoying issue, when you try to copy from the SQL output, it only works if you have 2 or more cells selected.
If you select only one, it ouputs ""
I'm on Windows.

(Great tool btw, thanks a lot)

refresh button for browse data

add a refresh button to the browse data view + shortcut (F5)

Font in the SQL Log window is too small to read

Testing out SQLiteBrowser on OSX, the font in the SQL Log window is too small to read.

SqliteBrowser 3.0.1: column and table names with non ASCII characters break the GUI

Dear all,
with
SqliteBrowser 3.0.1
Qt Version 4.8.5
SQLite Version 3.7.17
on Win 7 64bit,

the GUI breaks (displaying nothing) at various location if a column name (or a table name) contains non ASCII characters like umlauts (äöü...) or Greek letters (βγρ...).

To reproduce:
a) Create a table/field which contains an umlaut (äöü...) or Greek letter (βγρ...) in its name.
b) Try to modify the table.
c) Try to "Browse Data".

Results:
a) From SQL Log:

CREATE TABLE `lösungen` (
    `punkte... <string can not be logged, contains binary data> ...

Table successfully created. If saved and opened with the Firefox Addon "SQLite Manager" 0.8.1 the table is there and can be filled with data.

b) The field area is empty.

c) Browse Data tab is empty.

Also:
SQL Log, when "Modify Table" clicked on a table with a column containing a special char:

ALTER TABLE `asdf` ADD COLUMN   `... <string can not be logged, contains binary data> ...

The field area is then empty in the dialog box.

Anyhow, the "Schema" column in the "Database Structure" tab shows the correct table and column names.

tables with keywords in name or colum name

If a table has keywords as column name or table name.
The sqlite3 parser wouldn't allow this e.g.:

CREATE TABLE deffered(
  key integer primary key,
  if text
);

Not all keywords are allowed to be directly used as table or column names, for example create, check ...
If you want such names you have to put it in quotes.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.