raddevus wrote: 2. It's super slow to use EntityFramework to insert those dir names into the sqlite db. Super slow means it takes more than 10 minutes. Take a look at my article[^] about sqlite multi-threading. Might give you some ideas how to speed up things. Mircea (see my latest musings at neacsu.net)

Probably. However, the best way would be to backup the DB on the PC A and then restore it on PC B.

I got your point.

Steve I decided to ask a question and try to solve the issue by opening Google and login when I opened the YouTube video. The mistake I only need to open Chrome.exe then open the YouTube channel. Now everything works sort of the ads show but I just mute or skip after a few second's here is the link to the question with the solution by OG Set default browser from a VB.NET application[^]

RedDk wrote: current FFB is now 72.0.2 Not sure where you're getting that from; the current release is 125.0.3, and even the ESR release is 115.x! If you're still running v72 or v68, then you are putting yourself at risk, since there have been a lot of security vulnerabilities patched since then. RedDk wrote: if I dare upgrade/update, my cache of "data" will be destroyed and all my bookmarks will be lost as well as my extensive history I've been using Firefox since a very early version, and have literally never seen that happen. Even the "refresh Firefox[^]" option would preserve your bookmarks, history, passwords, and cookies. If you're paranoid about losing your data, you can always backup your profile folder: Back up and restore information in Firefox profiles | Firefox Help[^] But presumably you're already doing that? "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Hi Rene, I have no experience with kdb+, and I don't know if it works with your development tools. I went to a couple of live demonstrations of it a few years ago. There is a "Q" programming language that was similar to SQL, and less verbose. I can't remember if it was aggregation, but the speed was incredible. You might want investigate it: kdb+ | KX[^] Hope that helps. Quote: Richard Rogers LinkedIn: https://www.linkedin.com/in/rrcdn/

I recommend to create database tables after you connect to the database. put this code at after creating conn variable to avoid tables does not exists issue. conn = sqlite3.connect('Chef__Order.db') conn.execute("""CREATE TABLE IF NOT EXISTS "Chef" ( "ChefID" TEXT NOT NULL, "Chefs" TEXT NOT NULL, "Meals cooked No." INTEGER, PRIMARY KEY("ChefID","Chefs") )""") conn.execute("""CREATE TABLE IF NOT EXISTS "Food" ("FoodID" INTEGER, "Food names" TEXT, "Ratings" INTEGER, "Price" INTEGER, PRIMARY KEY("Price", "Food names", "FoodID"))""") conn.execute("""CREATE TABLE IF NOT EXISTS "Members" ("ID" TEXT NOT NULL, "Names" TEXT, "Feedback" INTEGER, PRIMARY KEY("ID","Names"))""") conn.execute("""CREATE TABLE IF NOT EXISTS "Progression" ("OrderNo" INTEGER, "ID" TEXT, "Food" TEXT, "Quantity" INTEGER, "Price" REAL, "Progress" TEXT, FOREIGN KEY("ID") REFERENCES "Members"("ID"))""") This code will create table if it already does not exists and if it already exists it will not through any error and the program will run just fine.

Nice catch. I missed that one. Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak

An insert implies an index update; or a "split" somewhere. A simple append might be different. In effect, the "internal" state becomes dirty. Because it is "lite". "Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

Thanks for your response. What about this page? This says that there is: SQLite Syntax: upsert-clause[^] This is the INSERT statement, it clearly shows the upsert clause: SQLite Syntax: insert-stmt[^] The difficult we do right away... ...the impossible takes slightly longer.

I highly recommend the podcast with the original creator of SQLite The Untold Story of SQLite With Richard Hipp - CoRecursive Podcast[^] CoRecursive with Adam Gordon Bell is really great, but this particular one is one of the all-time best. You will get the details of how SQLite came to be and a lot of information of the challenges that Hipp had as he created it. Really great!!! I promise. :)

Pfff... where is excel when one needs it? :rolleyes: :laugh: M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

and that's where I walk my ass out the door. Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak

your observation made me wonder why I used string for year? As I was writing a small test app it happened with strict ON I had a issue converting a INTEGER to a String So I gave up and just made gvYear a string So you know I learned from my mistake gvYear = Convert.ToInt32(tbYear.Text) If you like you can look at my final solution here Link to CP Question[^] Thanks for the comment

You could create the database from code; use scripts or code to create your tables. It is far easier to create a DB that contains all tables but no data. Then you simply copy the empty DB to the appropriate location using the installer. That means, NOT in the "Program Files" directory. I'd expect this DB to live in a single user-account. If you want multiple users, then SQLite isn't your best starting-ground. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

You don't have to - forums here don't have a facility for that as they are discussion based rather than "Question / Answer". We have an area for those that has a "solved" indicator: Quick Answers[^] "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

Anyway, I appreciate you pointing out that it's not susceptible to injection attacks. That was the reason for my question. Thanks! The difficult we do right away... ...the impossible takes slightly longer.