Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 03:59
    atx49559 commented #3231
  • 03:56
    atx49559 commented #3231
  • 03:56
    atx49559 commented #3231
  • 03:56
    atx49559 commented #3231
  • 03:56
    atx49559 commented #3231
  • 03:55
    atx49559 commented #3231
  • 03:53
    atx49559 commented #3231
  • 03:51
    atx49559 commented #3231
  • Nov 30 19:41
    Crystal4276 commented #3101
  • Nov 30 19:39
    Crystal4276 commented #3101
  • Nov 30 19:39
    Crystal4276 commented #3101
  • Nov 30 19:36
    chrisjlocke commented #3101
  • Nov 30 12:57
    Crystal4276 commented #3101
  • Nov 30 10:12
    lucydodo commented #3236
  • Nov 30 10:11
    lucydodo labeled #3236
  • Nov 30 10:11
    lucydodo assigned #3236
  • Nov 30 10:11
    lucydodo opened #3236
  • Nov 30 09:28
    Hook25 commented #3127
  • Nov 30 09:23
    Hook25 commented #3127
  • Nov 30 08:15
    lucydodo commented #1688
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?"
Saying that because you're sounding pissed off about it, like I get when I haven't had a decent amount of sleep for too long. :frowning:
SeongTae Jeong
@lucydodo

@SafaAlfulaij I'm really sorry for the inconvenience and not understanding you.
The reason I didn't understand properly was because my native language wasn't English, so I lacked a lot.

Also, as @justinclift said, I have been involved in this project lately, so I'm still trying to learn and get used to the project.
Of course, I'm not trying to evade responsibility and no an excuse too, I am asking for understanding.

I will try to find out what you said and do not cause any inconvenience to the contributors. I apologize again. (Also, thank you for always paying attention to our project.)

Scott Furry
@scottfurry
KDAB released an enhanced QDocker library https://www.kdab.com/kddockwidgets-1-0-released/
arronlacey
@arronlacey
Is prior installation of sqlite / sqlite3 required or does DB Browser for SQLite take care of this?
Justin Clift
@justinclift
@arronlacey DB Browser for SQLite takes care of it. :smile:
Matthew Petty
@muteboy
Hi, I'm browsing data in my table "People in Bands", and I want to add a record. The table has a foreign key to the Bands table. The dropdown displays the Band ID, which is correct, but is there a way to make it also display the Band Name?
Matthew Petty
@muteboy
Having trouble creating an INSTEAD OF .. UPDATE trigger for a view. View updates, but table does not.
Justin Clift
@justinclift
@muteboy Sorry for the delay in response. We're pretty active on GitHub, but not so much in the various chat places. ;)
Scott Furry
@scottfurry
Reading material - joining external repositories in CMake: https://kubasejdak.com/how-to-join-repositories-in-cmake
Justin Clift
@justinclift
Cool, that could be useful at some point. :smile:
Christopher
@cklester
where can i find docs about doing a composite foreign key contraint? (e.g., FOREIGN KEY(songartist, songalbum) REFERENCES album(albumartist, albumname))
*constraint :)
Justin Clift
@justinclift
@cklester The reference docs for it look ok: https://sqlite.org/foreignkeys.html#fk_composite
eg, they seem pretty readable. For specific follow up info, I'd probably ask on the main SQLite forum. :smile:
Scott Furry
@scottfurry
Karani Uyar
@KaraniUyar
hi, DB Browser SQLite I have table not insert to FK key? I can't add FK to the table
do i need to open a setting,
Karani Uyar
@KaraniUyar
ok i am fix. one step: DROP TABLE suppliers; after create table..
Thank you
Chris Locke
@chrisjlocke
Dropping the table after creating it would just delete it again. Are you sure that's what you mean?
What do you mean by 'not insert to FK key' ?
I appreciate you've resolved this, but I'm not convinced you've actually resolved it... if you follow...
Scott Furry
@scottfurry
jessie-github
@jessie-github
HI. Not sure if this is a limitation of DB Browser or not: I have a huge table (25GB) with an index on column "ID". If I execute "select * from table where ID = 123, this is very fast (almost instant result). But if I try to use the Browser with a filter (ID = 123), it takes 20 seconds to display the count number with a lot of "loading" for the cell values. Then I have to wait 2-3mn in order to have the values displayed. Is it expected or am doing something wrong ? Thanks
Tested on v3.12.1 in Windows 64
jessie-github
@jessie-github
Nevermind, I found the issue: I forgot to use the "=" operator...slap forehead
Hilmi Kaan Genç
@Ciyradyl
Hey guys, I have an android project and I created my database via SQlite Browser also I'm using kotling at android side but i didn't find any source about how am i going to connect my database with my android app. Do you have any resource? (video, article etc.)
Chris Locke
@chrisjlocke
Kotling? Did you mean Kotlin? (https://kotlinlang.org/)
You say you didn't 'find any source' - have you seen this tutorial?
https://www.javatpoint.com/kotlin-android-sqlite-tutorial