Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Aug 14 11:54
    chrisjlocke commented #3122
  • Aug 14 11:38
    zoseph-green closed #3122
  • Aug 14 11:38
    zoseph-green commented #3122
  • Aug 12 23:04
    chrisjlocke commented #3133
  • Aug 12 23:03
    chrisjlocke commented #3133
  • Aug 12 20:24
    megahypercat opened #3133
  • Aug 12 20:15
    megahypercat commented #817
  • Aug 12 13:16
    justinclift commented #3105
  • Aug 12 06:42
    chrisjlocke labeled #3127
  • Aug 12 06:42
    chrisjlocke commented #3127
  • Aug 12 06:18
    Ninon77 closed #3128
  • Aug 12 06:18
    Ninon77 commented #3128
  • Aug 12 05:46
    chrisjlocke commented #3128
  • Aug 12 05:45
    chrisjlocke labeled #3132
  • Aug 12 05:45
    chrisjlocke labeled #3132
  • Aug 12 05:45
    chrisjlocke commented #3132
  • Aug 12 04:01
    frankstrobel opened #3132
  • Aug 11 17:10
    eevleevs commented #3125
  • Aug 11 16:09
    chrisjlocke commented #3105
  • Aug 11 15:57
    chrisjlocke commented #3105
SeongTae Jeong
@lucydodo
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
Hilmi Kaan Genç
@Ciyradyl
@chrisjlocke I was looking for something like a video but this is also good thanks buddy. I will check this out.
Selvaganesh
@selvaganesh3m

CREATE TABLE IF NOT EXISTS categories (
category_value VARCHAR(4) NOT NULL PRIMARY KEY
);
INSERT INTO categories (category_value) VALUES ("food"),("trav"),("cine"),("misc");

CREATE TABLE IF NOT EXISTS Expences (
expence_id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT(64) NOT NULL,
description TEXT(255) NOT NULL,
amount DECIMAL (5,2) CHECK(amount > 0 and amount < 10000.00) NOT NULL,
transaction_date DATE NOT NULL,
category_value VARCHAR(4) NOT NULL,
FOREIGN KEY (category_value)
REFERENCES categories (category_value)
ON UPDATE RESTRICT
ON DELETE CASCADE);

Please can someone tell me what wrong with this
Chris Locke
@chrisjlocke
Sqlite doesn't support varchar for a start ... only text, integer, numeric, real and blobs. I assume you're copying this from another source to replicate in sqlite?
When you say, "what's wrong with it" what are you asking - what part of it isn't working? Are you getting errors? What error? It's a bit not working? Which bit?
Selvaganesh
@selvaganesh3m
My doubt is is in foreign key reference part
whether the foreign key referred is right or wrong thats my doubt the whole declaration part is wrong I thing
That's what need an Explanation why it is Wrong
Chris Locke
@chrisjlocke
image.png
OK, have put all that lot into DB4S, and it just swallowed it.
Again - what makes you think it's not working - what isn't working.
Chris Locke
@chrisjlocke
If I add 'blah' as a category, it doesn't like that, which is as expected.
image.png
If I enter 'misc', it does.
image.png
That what the constraint is for - it'll only allow values you've entered into the categories table.
image.png
Chris Locke
@chrisjlocke
In an ideal world, the category table would be like the expenses table and have an ID, and you'd link on that id, not the word itself. Later on, it'll be problematic to rename 'misc' to something else - you'd have to add a new entry and edit every record which points to 'misc'. One line of SQL, but still problematic.
brightinnovator
@brightinnovator

Hi,

I have 5,000 txt files. I want to create a mobile app to do full text search

When i looked for it few suggested the following

a) use sqlite fts5 (or)
b) search-index library

I'm now sure what the drawbacks and how much slower sqlite would be when to do a full text search for 5,000 files which can be converted to 5,00,000 records as each file would have 100 paragraphs and each paragraph can be saved as a row

Is it worth to put 5 lakhs records in SQLite and do a full text search. Will it be faster?

Please let me know in detail

Thanks

sebastianolafhandjojo
@sebastianolafhandjojo
Hi , i would like a request , a check box to enable/disable latest release on startup, because we are behind firewall