Development discussion for DB Browser for SQLite (previously SQLite Browser)
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?
https://bit.ly/submitBug
I have a question on javascript
This is primarily a support chat area for DB4S which is a database management tool. I don't believe the users familiar in it are also familiar with Javascript.
Can I get Gitter to send me an email for responses?
If you click the settings (assuming you're on the desktop browser version) there are notification options in there. Click 'Notifications' and not 'Settings' (once you've clicked the settings icon, I mean...)
1 reply
'String', "String" and String when running any query? I noticed they're all work when asking data from the DB, using those DB names and row names.
Carlos - You have a number of SQL engines (mySQL, Microsoft, etc) and SQLite tries to help out by being compatible with them as they all work a little differently. This means you could use an apostrophe or quote but SQLite tries to work out what you really mean.
Generally, strings are enclosed in apostrophe's, so select from table where field1='Fred' means it'll find data that matches the string 'Fred'. If you use field1="fred" then it tries to find a column (or table, view, etc) that matches "fred". BUT, if it doesn't find one, SQLite thinks, "aah, did you mean 'Fred'?" so that might also work. You shouldn't rely on these though, and should ideally get the quotation marks correct.
Ideally, all fields and tables should be a singular word without spaces. So don't call a table "table 1". If you do, you have to put quotation marks around it (not apostrophes) when using it in SQL - eg, select from "table 1" where field1='Blah blah'
Does any of this make any sense?
1 reply
I don't have any issue with a 5GB database.
On the "Browser Data" tab, the row count is displaying after a few seconds at the bottom and after that it is frozen with the bottom right message "Busy (reading rows)".
I have set the prefetch value to 255, but it doesn't help.
CPU usage is high but I still have enough RAM available.
Can somebody tell me if I have missed something ? I don't want to re-open the issue and bother the developers if I made a mistake... Thanks !