Development discussion for DB Browser for SQLite (previously SQLite Browser)
https://www.javatpoint.com/kotlin-android-sqlite-tutorial
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);
Again - what makes you think it's not working - what isn't working.
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
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.
When you say 'corrections', how much entry is entered?
You mention you're using a SQLite database already, but what app is accessing this on the phone currently?
We are using the query tool that comes with SQLite
I'm still not sure what application you're using on your phones to view/amend the database. SQLite Browser (or Database Browser for SQLite to use it's official title) isn't available for Android/iOS.
There is a handy 'repository' called dbhub.io which allows databases to be uploaded and supports revisions, but again, this works within DB4S which isn't available on a mobile device.
This would be a simple app to create - mainly a search form, then select the entry to view the record, allow any updates which would set a 'date updated' flag, so any records updated in the last X days could then be uploaded. Simple in theory...
While my .Net skills are good, I don't have the skills to create a Xaramin application, which would fit your bill nicely.
As an aside, whats the urgency of this - 'we want something now, now, now!!!' or 'we'll need something quick in a couple of weeks', etc. Could be an interesting project if you want to have a specific application written for you!
My doubt is
# fetch all orders that have 'pepperoni' as one of the toppings (either in pizza-topping or in additional-topping)I've written a query
SELECT
o.*
FROM
tom_orders AS o
INNER JOIN tom_pizza_toppings AS pt ON pt.pizza_id = o.pizza_id
INNER JOIN tom_toppings AS t ON t.id = pt.topping_id
WHERE
t.name = 'Pepperoni'
UNION
SELECT
o.*
FROM
tom_orders AS o
INNER JOIN tom_orders_addl_toppings AS addt ON addt.order_id = o.id
INNER JOIN tom_toppings AS t ON t.id = addt.topping_id
WHERE
t.name = 'Pepperoni'This is my query
So you've done the query - what is the issue?