Where communities thrive

Join over 1.5M+ people
Join over 100K+ communities
Free without limits
Create your own community

Explore more communities

sqlitebrowser/sqlitebrowser

Development discussion for DB Browser for SQLite (previously SQLite Browser)

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

FYI and future reference https://www.qt.io/blog/porting-from-qt-5-to-qt-6-using-qt5compat-library

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

FYI: CMake 3.19 feature - https://www.kdab.com/the-power-of-cmake-presets/

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

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.

If I enter 'misc', it does.

That what the constraint is for - it'll only allow values you've entered into the categories table.

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

Chat via Matrix