Stack Exchange
log in

Son Goku ssj4

 VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ
Son Goku ssj4
Jun 24, 2021 23:08
Np :)
Son Goku ssj4
Jun 24, 2021 23:08
user image
Son Goku ssj4
Jun 24, 2021 23:06
@FreeMan goo.gl/maps/Guci2uDFjEyYsWh5A
Son Goku ssj4
Jun 24, 2021 23:05
If you wander there, let me know. I can give you a small tour or just some tips :-)
Son Goku ssj4
Jun 24, 2021 23:05
@mansellan Go for it! In this time with our technologies, it's extremely easy to say something in English and phone says it in czech. And vice-versa. And for writing, this motherf**ker is awesome. deepl.com/translator
Son Goku ssj4
Jun 24, 2021 23:03
It is :-) I'm proud I'm from there. Love the nature. Hiking, bicycle, cross-country skiing. Everyone is always shocked I drink water from streams in woods. :-D
Son Goku ssj4
Jun 24, 2021 23:00
You would love it. See the gallery (ignore czech language)
https://www.idnes.cz/cestovani/na-kole/jeseniky-cyklotoulky.A140711_135343_na-kolo_skr
Son Goku ssj4
Jun 24, 2021 23:00
user image
Son Goku ssj4
Jun 24, 2021 23:00
@mansellan And the city and surroundings
Son Goku ssj4
Jun 24, 2021 22:57
@IvenBach We have the worst system. If it would be in the middle of city, it wouldn't last a week. But it's quite distant and you have to go 1km to the steep hill to get there 9 no cars) so most of the people are tourists. It's working for around 10 years.
Son Goku ssj4
Jun 24, 2021 22:56
@mansellan google.com/…
Son Goku ssj4
Jun 24, 2021 22:55
We have a "forest bar" where you can get what you want and leave (or not) any money you want. :D
Son Goku ssj4
Jun 24, 2021 22:54
Isolation? Go to Jesenik. My birth city. 11K people, nature everywhere, hills, extremely clean water, public spa places :-)
Son Goku ssj4
Jun 24, 2021 22:51
user image
Son Goku ssj4
Jun 24, 2021 22:49
@mansellan Everything is fine until those big spiders get wings...
Son Goku ssj4
Jun 24, 2021 22:44
@FreeMan I've read you've got like 600 tornados per year?
Son Goku ssj4
Jun 24, 2021 22:44
Yeah. No problem in my locality anymore. Will do. :)
Thanks everyone.
Son Goku ssj4
Jun 24, 2021 22:41
Just wanted to share some info. Going to sleep now. :-) See'ya.
Son Goku ssj4
Jun 24, 2021 22:40
@FreeMan Wow. I don't envy you.
Son Goku ssj4
Jun 24, 2021 22:38
@mansellan In Czech Republic, there is like 1 tornado per 2 years. But never this strong. The last strong tornado in CZ was in 13xx I think. Heard that today in some video.
Son Goku ssj4
Jun 24, 2021 22:37
Pretty! :-)
Son Goku ssj4
Jun 24, 2021 22:37
photos.app.goo.gl/dfeqiiZ11FevoL4P8
Son Goku ssj4
Jun 24, 2021 22:37
I've recorded this after everything ended. These are distant lightnings.
Son Goku ssj4
Jun 24, 2021 22:35
user image
Son Goku ssj4
Jun 24, 2021 22:35
Not as bad as in the Breclav (friend is from there)
Son Goku ssj4
Jun 24, 2021 22:33
Thanks. Those 2 villages are totally destroyed. Austria, Slovenia helping, people on FB offering places to stay, things, really good peeps.
Here there was only a "medium blizzard".
Son Goku ssj4
Jun 24, 2021 22:32
Incredible footage of Tornado in Czech Hodonin - Tornado Tschechien
►
Son Goku ssj4
Jun 24, 2021 22:32
Some people even took a footage of it.
Son Goku ssj4
Jun 24, 2021 22:31
bbc.com/news/world-europe-57605651
Son Goku ssj4
Jun 24, 2021 22:31
Wow... So this happened few hours ago 40 kilometers from me
Son Goku ssj4
May 30, 2021 00:10
Async JS functions are PAIN.....Can't comprehend them...
Son Goku ssj4
May 20, 2021 22:28
:-) You made my day.
Son Goku ssj4
May 20, 2021 22:28
After my last cry few weeks ago (when I even posted gifs that it's unusable when clicking faster than 1 click per 5 seconds), I think something has changed for sure.
Son Goku ssj4
May 20, 2021 22:26
It's bloody fast! After like 2 years it's immensely more usable now than ever! Loving this.
5
Son Goku ssj4
May 20, 2021 22:24
What did you do???
Son Goku ssj4
May 20, 2021 22:23
Just installed the last RD version.
Son Goku ssj4
May 12, 2021 18:30
If I have some form in VBA and settings are on a sheet, the process should be the same? Load into an object in memory, then always check if the object exists, if not, load it up, if yes, use the value, then if settings changed, write it to the object and to the sheet?
Son Goku ssj4
May 12, 2021 18:28
Ah okay. So download settings once. Store them into cache. When getting the value, always check if settings are loaded. If not, load them.
In Settings windows, if I change something, it should write both to DB and modify the Cache.
That's good.
Son Goku ssj4
May 12, 2021 18:26
For the RD (because RD has TONS of settings) the same - I'm not sure how that works.
Son Goku ssj4
May 12, 2021 18:25
And on the another note - how are typically these settings applied? Let's say I have 2 pages and in settings the page width and background color. (Or for some practical example in RD: if for example autocompletion should work (fire) after each key press. in VBE)

If I visit the first page, I should download the settings. That's logical. But when I visit the second page, isn't it a waste of time to download it again?

But if I save it in browser cache for example and change the background from black to white, how does the new page know which settings to apply? Or should there be something li…
Son Goku ssj4
May 12, 2021 18:22
:D
Son Goku ssj4
May 12, 2021 18:20
So something like MongoDB? I haven't tried NonSQL databases yet... Don't know what to expect or if you can (should) combine them.
Son Goku ssj4
May 12, 2021 18:18
It would be interesting to find out how for example Youtube stores this. There are 2.3 billions of users so... It has to be somewhat quick and intelligent.
Son Goku ssj4
May 12, 2021 18:17
"SQL Server does support parsing & building JSON in transact-SQL so you have that going." <-- @this is really interesting. Will google that up. :)
Son Goku ssj4
May 12, 2021 18:16
@this @MathieuGuindon Thanks for the input. I was thinking about storing UserId, Settings (or SettingsCategory), Value (JSON parsable string). But few articles on the internet were quite against it because it's impossible to filter queries. You just get it all at once.
But I suppose that depends on what the app is, size, how much settings, etc etc.
Son Goku ssj4
May 12, 2021 15:17
But wanted to discuss my options if there is anyone that has tried this in the past.
Son Goku ssj4
May 12, 2021 15:17
I'm thinking how would I do user-settings for +- 300 people, +- 25 settings for each. When I read on the internet, having 25 (26 with useriId) columns in your DB is a bad, bad idea. So I found out there is something called "Property bag" so you save each settings to 4-column db table (userId, settingsName, key, value). In this example I would have around 300 * 25 = 7500 rows which is nothing.
Son Goku ssj4
May 12, 2021 15:14
Anyone here that tried to make an web application where user can login and have the ability to save some user settings (which then saves into SQL relational database?)
Son Goku ssj4
May 11, 2021 20:25
Well, I had my bright moment through today's morning. It finally caught me up. I'll finish my wine and will be getting to bed...
Sry about that Mug :-)
Son Goku ssj4
May 11, 2021 20:23
facepalm