Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 10:14
    rebeccaXam commented #1634
  • 02:16
    justinclift commented #3267
  • Jan 31 23:20
    jlw4049 commented #2142
  • Jan 31 17:55
    Jonny007-MKD commented #3267
  • Jan 31 15:55
    qrockz closed #3269
  • Jan 31 15:00
    chrisjlocke commented #3269
  • Jan 31 14:22
    justinclift commented #3269
  • Jan 31 05:08
    qrockz edited #3269
  • Jan 31 05:08
    qrockz edited #3269
  • Jan 31 05:04
    qrockz opened #3269
  • Jan 30 20:41
    justinclift commented #3267
  • Jan 30 20:32
    justinclift commented #3268
  • Jan 30 17:42
    Jonny007-MKD commented #3267
  • Jan 30 17:41
    Jonny007-MKD commented #3267
  • Jan 30 17:18
    scottfurry commented #3267
  • Jan 30 17:11
    scottfurry commented #3267
  • Jan 30 17:09
    scottfurry commented #3267
  • Jan 30 17:00
    Jonny007-MKD commented #3267
  • Jan 30 16:53
    scottfurry commented #3267
  • Jan 30 16:48
    Jonny007-MKD commented #3267
Scott Furry
@scottfurry
I haven't actively used a Win box in years but even I know mixing versions of dll's is bad. This sounds like dependency version management malfunction.
Justin Clift
@justinclift
Yeah. :smile:
IoTFier
@IoTFier
Hi, how do I update exiting installation of sqlitebrowser with new version ? The .msi shows change / repair / remove option but it is not upgrading previous .11 one
Justin Clift
@justinclift
@IoTFier Hmmm, in that case it's probably best to choose the "Remove" option for the 3.11 one, and do a fresh install of the 3.12 one.
If that doesn't work either, let us know. :)
Luxnews
@Luxnews
Good morning, I'm using DBBrowser for SQLITE V 3.12.0. I'm afraid I've discovered a little bug in exporting SQL generated tabel. I've created a big table (about 700MB). Trying to export it it is full of alphanumeric fields and although filled double quote as Quote Character, this char is never used as a surrounding char for alphanumeric fields. It happens even with single quote char of other char: they're never used as expected.
Martin Kleusberg
@MKleusberg
@Luxnews Quote characters are only added when needed. So usually a value will not be quoted. But when it contains a line break, a field separator character, or another quote character it is quoted. This is in line with https://csv-spec.org/ which says: "It is possible to enclose every field in double quotes even if they don’t need to be enclosed. However it is RECOMMENDED to only enclose fields in double quotes that requires it." Do you absolutely need to have each field quoted? We could add a configuration option for that then.
Luxnews
@Luxnews

Hi Martin, thanks for answering me so soon. I know, that's true (the fact that surroundings field chars are not always a must), but I think a "compelled" surrounding char (for alphanumeric or all fields) could be a good idea.

Excel is not so smart in "understanding" CSV files (and it likes semicolon instead of comma... ;-) ).

As far as I remember though, (have to check on csv-spec.org) if a field is full of spaces and is text, it could be very likely be surrounded by single quote, double quote or other char. This is NOT a must, but not al CSV parsers are as good as the CALC (by libreoffice) one, and some of them fail if not well syntactically instructed ;-).
Anyway SqliteBrowser is a very good piece of sw... although the "Browser" part of the name, is a bit reductive: it is much much more than a simple browser!
Luca

IoTFier
@IoTFier
Hi @justinclift , @scottfurry - is there a good sample Sqlite database that you would recommend which covers latest Sqlite db version and all data types in it ?
IoTFier
@IoTFier
anyone tried using northwind database - ref ... https://database.guide/2-sample-databases-sqlite/ ?
Chris Locke
@chrisjlocke

latest Sqlite db version and all data types in it

Data types in sqlite hasn't changed. https://www.sqlite.org/datatype3.html
Its still nulls, integers, reals, text and blobs.

Luxnews
@Luxnews
Oh I forgot to highlight a little problem with long "headers". My genetic file has 19 comment # lines, then there is the header at line 21 and from 22 start the datas. In this situation I had to cut away manually first 20 lines (with sed) in order to be able to import them to sqlitedbbrowser. It would be nice to be able to jump some lines of the useless comments header. I'll prepare an example to show the problem.
Evgeniy Karyakin
@Unchqua
I'm pretty sure I'm not the first who propose this but couldn't find anything like this in DB4S Github website except this neat page: https://github.com/sqlitebrowser/sqlitebrowser/wiki/Keyboard-shortcuts .
Can we have keyboard shortcuts for "Insert a new record" and "Delete the current record"? Both actions are so frequent here for me and I'm afraid my mouse suffers a lot as I click it so often on these buttons. Also, and this is no less important, it must confirm the deletion as this is a destructive action. And we don't have Ctrl-Z at all.
Evgeniy Karyakin
@Unchqua
Another proposition, if you please. Make toolbars' button sets editable. That is, to remove and/or rearrange buttons. That "Print table data" buttons sits just beside the "Insert a new record" one and I constantly hit it accidently. I guess one needs to print a table once a month, and add records much more frequently than that, many times a day.
Evgeniy Karyakin
@Unchqua
And another one, this time it's UI enhancement. When in "Add New Record" Dialog, I can navigate, by means of keyboard, through its elements BUT cannot reach that "Value" column where I enter my values. So instead of keeping my fingers entirely on the keyboard I have to reach my mouse, click "Insert" toolbar button and then click the first mandatory Value field, and only after that I return to the keyboard to input everything and then Ctrl-Enter to submit. This, by the end of the day, takes much time both to change keyboard-mouse devices and to target screen buttons again and again.
I consider DB4S the best SQlite database manager and GUI and I'm not going to replace it for anything else. Thank you guys for developing it!
Chris Locke
@chrisjlocke

Can we have keyboard shortcuts for "Insert a new record" and "Delete the current record"?

Ideally, these requests should be requested on the github page (https://github.com/sqlitebrowser/sqlitebrowser/issues) as they're then logged, and the code is linked to the issue. You'll also be notified when the request has been added.

And we don't have Ctrl-Z at all

You do have a 'revert changes' button... ;)

When in "Add New Record" Dialog, I can navigate, by means of keyboard, through its elements BUT cannot reach that "Value" column

Can you not use the grid for entering data? A new record adds an empty row at the bottom of the grid, and you can enter your data ala Excel.

Evgeniy Karyakin
@Unchqua

@chrisjlocke Thanks for the replies!
I will submit that new shortcuts request to Github, sure.

You do have a 'revert changes' button... ;)

"Revert Changes" drops everything since last save, it cannot correct my last action only… Imagine I input 10 records right and then did a mistake at the 11th—I cannot drop it all.

Can you not use the grid for entering data?

Grid only appears when a table is simple enough? For example, one of my tables has ~10 columns, some of them being mandatory, and no matter if I choose "New Record" or "Insert Values…" option I get modal Add New Record window where I can't navigate to the Value column easily.

Chris Locke
@chrisjlocke

Yes, if you have some fields (I believe) set to 'Not Null', then an empty row can't be inserted, so the dialog pops up.

Undo...

I think there were discussions about using savepoints, but the database isn't committed until the last savepoint is committed, so if there was a series of savepoints, at every insert/delete for example, you could undo going backwards, but would need to hit 'Save' to commit which would kill all the undos. You just know someone is going to hit Save /then/ want to undo...

Evgeniy Karyakin
@Unchqua
@chrisjlocke
OK, being a programmer too I see it's not an easy take to implement undo-redo functionality. Still, it's easy to add defensive confirmation OK/Cancel window before you actually delete a record. Will submit this request at Github along with keyboard navigation shortcuts.
Thanks!
Chris Locke
@chrisjlocke

OK, being a programmer too

In what? I mainly do vb.net stuff, so this C++ is a little beyond me....

Evgeniy Karyakin
@Unchqua

In what? I mainly do vb.net stuff, so this C++ is a little beyond me....

It's PHP now, former Java dev. C++ isn't my way of life either…

Justin Clift
@justinclift
@Unchqua When you're entering data, are you using the tab key to change between fields? Asking because when I'm entering lots of data in a single session, I use the tab key to move between fields. And if you press the tab key when on the last field of the last line, it automatically creates a new row and moves to the first field there.
Evgeniy Karyakin
@Unchqua
@justinclift
I know this behaviour and it suits well when filling one simple table down the line. My scenario though is different. I learn Greek now (my native is Russian), and as part of this effort I develop and maintain my own dictionary. It consists of many tables which are dependant one on another. Say, nouns have their own table which has links to various reference tables (type, gender, number, declension etc.), then every noun has 1+ translations, then every translation has 0+ usage examples, 0+ references into our paper textbook, etc. Another table bears links between words, like, "this one derives from that one", "to better understand this word, also look up that one", and so on; they're all foreign keys obviously. So, to enter another noun into my dictionary, I need to insert records into several tables in particular order. So I constantly switch between tables. This makes DB4S loose focus: after changing table, the focus is always on the first row; but I can use Ctrl-End to jump there, and Tab to start a new one.
Still, this Tab-based navigation doesn't work for tables which have some NOT NULL columns; you can only INSERT into it by calling Add New Record popup which you can only get by clicking corresponding icon on the toolbar.
It would be just great to have a shortcut for that "New Record" button, with the same behaviour: Grid input for simple tables, and popup window input for anything more complex (plus to be able to reach Value column with Tab key).
Luxnews
@Luxnews

Oh I forgot to highlight a little problem with long "headers". My genetic file has 19 comment # lines, then there is the header at line 21 and from 22 start the datas. In this situation I had to cut away manually first 20 lines (with sed) in order to be able to import them to sqlitedbbrowser. It would be nice to be able to jump some lines of the useless comments header. I'll prepare an example to show the problem.

Here is the example I described some msg before:

http://thinkitbetter.com/store/dl/Annot-SAMPLE.zip

It is a genetic hugely modified and cut of only 10K lines instead of 850K. I was able to load it in sqlitedbbrowser only after having deleted first 20 lines manually from a text file of 1GB+ :-( ...

Chris Locke
@chrisjlocke

So I constantly switch between tables

Just a nod that you might like the latest dock implementation then ... multiple 'browse data' windows on screen at once...

Justin Clift
@justinclift
@Unchqua Makes sense. :smile:
Hopefully someone gets around to adding a visual form editor at some point, so people can make their own UI's for inputting data. There's a request for it in our GitHub somewhere.
@Luxnews Would you be up for creating a request on our GitHub about it? Something like "Allow skipping user defined # of first lines when importing a CSV".
We've started putting together the pieces for a 3.12.1 release, and at first glance this seems like a simple enough change that it could be included. :)
Scott Furry
@scottfurry
@IoTFier - cool catch. I'm tucking away the sample db link.
@Luxnews missed your comment from earlier. If there are proper comment markers in the file, the header stuff should just be ignored by sqlite. Bash-like comments are not valid in sqlite or sql. I think the choices are lua-like (double dash '--') or c-like (/* */).
Scott Furry
@scottfurry
@Luxnews That sample you had was a csv, not sql. Ooppps.
Scott Furry
@scottfurry
@MKleusberg @chrisjlocke @justinclift - I think @Luxnews ' issue points to something that we may be overlooking. There isn't a standard to go by for csv but other parser implementations do have a setting to denote a comment line delimiter (see SO link: https://stackoverflow.com/questions/1961006/can-a-csv-file-have-a-comment). May be useful to look into this "feature". (and I can't shake the feeling we've had this conversation before)
Scott Furry
@scottfurry
FYI - http://qmlbook.github.io/ looks interesting (and doesn't appear to proselytize like last link I posted).
Justin Clift
@justinclift
Oh. Skipping over comments is a good idea. It's probably pretty easy to implement too. :smile:
Scott Furry
@scottfurry
In case anyone missed it... QT6 is in feature freeze. Expect Release Candidate. https://lnkd.in/e5YCh48
Justin Clift
@justinclift
Interesting. Qmake is clearly on the way out:
QMake as the build system used in Qt 5 has lots of quirks and limitations. For Qt 6, we aim to use CMake as a standard 3rd party build system to build Qt itself. CMake is by far the most widely used build system in the C++ world, and better integration with it is sorely needed. We will continue to support our users on QMake, but not develop it further or use it to build the Qt framework itself.
Gah. Looks like Gitter has stopped respecting line breaks in quoted text. That's not good. :frowning:
Can't really claim good support for markdown (with any honesty) any more. :wink:
Safa Alfulaij
@SafaAlfulaij
Hello guys
Where are the released qs translations in the Windows version?
I found Qt files only..
Want to test the translation
Safa Alfulaij
@SafaAlfulaij
Got it
Safa Alfulaij
@SafaAlfulaij
Hey @lucydodo
Tbh, I can't understand why you didn't just inform the translators that shortcuts are special and should be treated with care, instead of resorting to such a strange and illogical solution as removing all the shortcuts..
And one shouldn't just allow any translator to translate thier app
Story translation is different than software translation
SeongTae Jeong
@lucydodo
Hi @SafaAlfulaij

There has already been a mention of this on our wiki.
However, I can not say that I am not responsible by just for mentioning on the wiki. I really sorry about this.

From next time, I will try to make it clear inform to the translators.
Maybe I can add comments in all shortcut entry(When do like this, Translators can check it in Qt Linguist).

Thank you for always taking the time to contribute to the our project.

Please feel free to tell me if you have any other opinions, requests or questions, I will do my best to help you.
Safa Alfulaij
@SafaAlfulaij

That wasn't what I mean
What I mean is that dont workaround problems that can be simply fixed by informing.

I know a lot of "translators" that would come and ask you that HTML and placeholders are not of thier business.
We can't remove such stuff.
That's what I meant

You don't need to be sorry. My idea is to make translators cope with the tech behind software translation.

Justin Clift
@justinclift
@SafaAlfulaij Please don't get too bent out of shape about it. @lucydodo is new to this stuff, and is putting in tonnes of effort. But he's very much doing stuff in good faith. Clearly some learning and adapting is still happening.
eg "Hey, could you do XYZ next time around, instead of ABC?"