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
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
Chris Locke
@chrisjlocke
No problem! Hope it resolves your issue. 😊
TheDemLabs
@TheDemLabs
Suggestions on the easiest way to share data to non-technical users who will be canvassing offline in the field using their phones? The file size could be upto 1m records but only have 6 columns. Search by Name & Date of Birth. Display Address, Phone, Voting status. Volunteers will make any corrections and then upload them when they have connectivity. Right now we are using SQLite to put the data on the phone but I need a simpler interface for volunteers to work with the data. Thanks.
TheDemLabs
@TheDemLabs
@chrisjlocke Hi Chris, Any suggestions on the easiest way to share data to non-technical users who will be canvassing offline in the field using their phones? The file size could be upto 1m records but only have 6 columns. Search by Name & Date of Birth. Display Address, Phone, Voting status. Volunteers will make any corrections and then upload them when they have connectivity. Right now we are using SQLite to put the data on the phone but I need a simpler interface for volunteers to work with the data. Thanks.