Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 01:43
    longnguyen2004 commented #3120
  • 01:13
    longnguyen2004 commented #3120
  • Aug 08 19:42
    evbo commented #3120
  • Aug 08 18:38
    longnguyen2004 commented #3120
  • Aug 08 18:36
    chrisjlocke commented #3126
  • Aug 08 18:33
    chrisjlocke commented #3126
  • Aug 08 18:17
    richb-hanover commented #3126
  • Aug 08 18:08
    evbo commented #3120
  • Aug 08 15:53
    chrisjlocke commented #3125
  • Aug 08 14:50
    evbo commented #3120
  • Aug 08 14:28
    longnguyen2004 commented #3120
  • Aug 08 13:55
    evbo commented #3120
  • Aug 08 12:27
    justinclift commented #3120
  • Aug 08 11:37
    longnguyen2004 commented #3120
  • Aug 08 11:32
    longnguyen2004 commented #3120
  • Aug 08 11:28
    longnguyen2004 commented #3120
  • Aug 08 11:26
    longnguyen2004 commented #3120
  • Aug 08 09:43
    MKleusberg commented #3122
  • Aug 08 08:59
    Hook25 opened #3127
  • Aug 08 08:47
    longnguyen2004 commented #3120
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
Chris Locke
@chrisjlocke

Hi,

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

You don't need SQLite for this. SQLite is a database - to store data. Doesn't sound like your data is changing. Just search the text files for the search text and display any results. Using a database for this would be like using a hammer to make a milkshake. Possible, but unnecessary.

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

If you click 'Edit' then select 'Preferences', you should get a tabbed dialog of many options. The first tab is 'General'.
Near the bottom of this is an option, 'Automatic updates'. If it is ticked, then DB4S will check for updates. If this is unticked, then it won't. Uncheck this option, then click on 'OK' and restart DB4S to confirm you no longer get an error at startup.

image.png
sebastianolafhandjojo
@sebastianolafhandjojo
ok thanks didn't realize that