|
Rob Philpott wrote: Where do you store the SQLite files, in a database?
That's a funny thought. No, each user gets their own "user-space" (in the file system on the remote machine) where their sqlite db will be stored.
Rob Philpott wrote: I guess the thing here is if you ever want to do a query that spans multiple users you are somewhat scuppered.
Aha! You're thinking like a data-mining corp.  This is my point too.
I'm saying each user owns their own data in their own sqlite db.
It's just literally a way to help them make their data remote (for the sole purpose of making it available to their own various devices).
I'm also suggesting that since it is their own data, they can delete it or whatever. They'll be able to download it so a "local" copy of my app will run against the data so if they want to go "offline" with the app they can.
And, I don't plan on doing a "multi-user" search or examining the user's data at all. It's theirs and it's just so the data in the app can be accessed for the user's purpose...not so some evil empire can examine their data to sell them products.
This is also why I'm interested in this. if it is possible (technology-wise) and it should be then it means that software could work great for the end-user without ever having to have some evil empire looking at the user's data.
of course, that means if the customer deletes or destroys the data then it is gone. My app offers no help with that beyond user doing their own download/ backup. Swim at your own risk. But also you own your data.
|
|
|
|
|
Rob Philpott wrote: Trying to think too far ahead is perhaps a tendency that kills things dead. Does this ring bells with anyone?
It is so rare that it even got a name: "analysis paralysis". And an Wikipedia article to document it: Analysis paralysis - Wikipedia[^]
Mircea
|
|
|
|
|
Ha! Wikipedia, has an answer for everything doesn't it. Know-it-alls. Had no idea it was a documented thing.
Interesting page, and I look forward to exploring the 'decision fatigue', 'existential crisis', 'information overload' and 'regret' links at the bottom! Right up my street.
Regards,
Rob Philpott.
|
|
|
|
|
That might lead you to "meta analysis paralysis" where you get stuck analyzing the analysis paralysis. From there you can move to higher and higher degrees until you reach the pure nirvana of just "laziness". You'll find me there waiting for you
Mircea
|
|
|
|
|
I struggle with that as well.
I have a few hobby projects that seems to go no-where.
One of my hobby projects has now been restarted 11 times.
Started on an Informix DB, converted it to Oracle, and now SQL Server. It started as a Delphi project, converted to C# / WinForms, and now WPF
Have been looking at WinUI, MAUI, Blazor, Aspire.
I know that it will go nowhere in the end, but it keeps me busy and I might learn a thing or two.
|
|
|
|
|
I think it was Abraham Lincoln who said that premature optimization was the death of a more perfect union.
Or something...
But sometimes, you just have to nerd out because the nerding out is the drive to keep moving forward.
|
|
|
|
|
Please tell me that it's not more than four, and that Dij's new nest discovery is now empty? 'Cause them were BIG chicks and he's bringing me the corpses in pairs ... 
There are times when it's really good to have a cat around, and then there are other times.
"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!
|
|
|
|
|
My four chickens used to lay one egg a day like clockwork.
Then it was 3 some days. One or more of them was slacking.
Now we're lucky to get an egg at all. The chooks are getting old.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
modified 19hrs ago.
|
|
|
|
|
honey the codewitch wrote: They chooks are getting old.
Time for chicken soup? 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Depending upon what birds they are, can even be 6 or more.
Sorry 
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|
|
Bugger.
These chicks had no feathers and they were all around 12cm long (ignoring the legs) so I'm guessing quite big birdies were involved. The only colour I could see was red and that came from the inside, so that doesn't count or aid identification ...
Dij isn't talking so I'm getting nothing there either.
"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!
|
|
|
|
|
Having seen the size of the eggs, I would hope for the bird's sake no more than one at a time! 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Nature taking it's course I guess.
|
|
|
|
|
Yes, I agree, I missed my cat when he died but I've never missed what he used to bring home. I'd never have another one.
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
The neighbor's cat keeps me entertained.
Whenever he walks by the tree in my yard, the bluejays fly down from their nest to greet him with a few good solid pecks on the head. He wanders around for a while wondering how he became the prey instead of the hunter.
Some day he'll learn that even pretty birds can protect their young.
CQ de W5ALT
Walt Fair, Jr.PhD P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Wordle 1,088 5/6*
⬛⬛⬛🟩⬛
⬛⬛⬛🟩⬛
🟩🟨⬛🟩⬛
🟩⬛🟩🟩⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 1,088 6/6
🟩⬜⬜⬜⬜
🟩⬜⬜⬜🟨
🟩🟨⬜⬜⬜
🟩🟨⬜🟩⬜
🟩⬜🟩🟩⬜
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 1,088 3/6*
⬜⬜⬜🟨⬜
🟩⬜🟩🟩⬜
🟩🟩🟩🟩🟩
"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!
|
|
|
|
|
Wordle 1,088 4/6
🟩⬜⬜⬜⬜
🟩⬜🟩🟩⬜
🟩⬜🟩🟩⬜
🟩🟩🟩🟩🟩
|
|
|
|
|
⬜⬜⬜🟩⬜
⬜⬜⬜🟨🟨
🟩⬜🟩🟩⬜
🟩⬜🟩🟩⬜
🟩⬜🟩🟩🟩
🟩🟩🟩🟩🟩
thought I was going to fail
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 1,088 3/6*
⬜⬜⬜⬜⬜
🟨⬜🟩🟩⬜
🟩🟩🟩🟩🟩
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|
|
Wordle 1,088 3/6
⬛⬛⬛🟩⬛
🟩⬛⬛🟩🟩
🟩🟩🟩🟩🟩
Ok, I have had my coffee, so you can all come out now!
|
|
|
|
|
Update: https://cse.usf.edu/~kchriste/tools/udpClientNonblock.c[^] Pretty much what I needed. Yay.
Update 2: Much ado about nothing. Easier than I thought. Docs are just terrible.
Anyone remember the sockets layer from C and C++?
Seriously, the fact that someone actually designed them the way that they did, and it made its way through a standards committee just floors me. The blocking stuff is fine, but the non blocking stuff is incomprehensible, at least last time I looked at it.
It's absolutely the worst asynchronous API I've ever encountered.
I'm about ready to use them in blocking mode on a spawned thread just to avoid it, but the MCU doesn't have a lot of resources and threads are relatively expensive. 
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
modified yesterday.
|
|
|
|
|
I'd be curious to hear more specifically what is wrong about the asynchronous socket API. What is the incomprehensible part.
Communication is, in its very nature, asynchronous. So an asynchronous socket API should be the natural way to do it. Synchronous communication is a straitjacket; you can't work or think freely if you have to force yourself into a synchronous framework for communication.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
IBM Documentation[^]
It's anything but natural.
Adding, I took a liberty here. I'm using non-blocking and asynchronous interchangeably, but they may not always be in every context.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
