What I've been doing is to click and drag to select code. Is there a hotkey that will select only the code? CTRL-A selects all text on the page.
Problem with submitting new topics
When I create a new topic and enter the mandatory tags, the tag dialog box sometimes overlays the "Continue to the Last Step" button leaving only the merest sliver of a button to click. Could the tag dialog be aligned left to avoid this?
Brace yourself for support spam
What are the odds. Three minutes before I popped in, we started getting support spam. I whacked 4-5 but I expect they'll keep coming.
Is This Considered Spam?
We are getting a burst of posts all from IP 180.188.224.184
Wouldn't be a concern except they are all similar in content but from five different usernames (they come in pairs). Anything to be concerned about? If it was on the up-and-up, why use multiple accounts?
Jason_54 How do I choose a router for my home?
Jason_54 How do I setup my tp-link router for the first time?
aaron_30 How do I log into my Roku account?
aaron_30 Why You Must Experience Orbi Login At Least Once In Your Lifetime?
jos_387 The Millionaire Guide On Dlinkrouter.local To Help You Get Rich?
jos_387 What I Wish Everyone Knew About Router.asus.com.
david_229 Learn From These Mistakes Before You Learn Re.rockspace.local.
david_229 The Biggest Contribution Of Tplinkwifi.net To Humanity.
james_161 How do I setup my Amped Wireless Extender?
james_161 5 Common Mistakes Everyone Makes In Myrouter.local.
How do I convert a SQLITE day number to a date string
I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as
select date('1899-12-31','Localtime','+44386 day') as dddd
which returns the single value '2021-07-09'. Unfortunately there seems to be no way to replace the hard coded number with the 'day' column. The original table also has the data broken down by hour (thus the GROUP BY clause), and by data_out and data_in (thus the SUM) So far I have
CREATE VIEW UsageByDay AS
SELECT day, SUM(data_in+data_out)/1024.0/1024.0 AS total
FROM usage GROUP BY day
ORDER BY day DESC;
Which gives me on select
DAY total
44386 45.2344284057617
44385 35.1123762130737
44381 26.000226020813
.
.
.
I want to replace the numerical values for day with the calculated date to give
DAY total
2021-07-09 45.2344284057617
2021-07-08 35.1123762130737
2021-07-07 26.000226020813
.
.
.
Any suggestions on how to modify my CREATE VIEW query?
User interface design
I found this great article on User Interfaces that I wanted to share. Two points I wanted to add
- Just because it's old doesn't mean it's bad.
- Just because it's new doesn't mean it's better.
And can we please all decide that light grey text on a white background is just retarded?
Free Technical Writing Tutorial
When asked, "What language should I learn first?", my answer is always "English". If you can't communicate clearly then you can't do your job as a programmer properly. As a programmer your job does not begin and end with code. You must also be able to write documentation clearly. I recently came across two excellent technical writing modules by Google that are free for everyone. They do not take long to complete and (aside from the confusion between acronyms and initialisms) are spot on. You can find the overview here with links to the two main modules.
A lot of you are shut in for the duration of the Covid-19 outbreak anyway so you have no reason not to at least have a look.