Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 66,091 through 66,105 (of 66,815 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 1

Steve Jones - SSC Editor wrote:

I've logged quite a few bugs lately on things. We've got a test site setup for an upgrade to PHP/WP/Nami, which is delaying work on other bugs. The upgrade will allow a forum software upgrade and that may or may not fix something, but no one wants to spend time on something that might be fixed.
I know, I know, the calculation page bug is super annoying. As is the no nav with 16 posts in a thread.
Plus holiday, but plus priorities elsewhere in RG. I ought to learn more about WP, but I find querying the DB maddening, and likely I'd start trying to throw away lots of stuff to make it work more like a RDBMS forum software and upset everyone.

Ummm... ok. Why not the best of both worlds instead of "upset everyone"?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 2

Steve Jones - SSC Editor wrote:

Grant's book: https://www.amazon.com/Server-2022-Query-Performance-Tuning/dp/1484288904/ref=sr_1_3?crid=3I1VV0HSNHD4T&keywords=grant+fritchey&qid=1672333097&sprefix=grant+fritche%2Caps%2C159&sr=8-3&ufe=app_do%3Aamzn1.fos.006c50ae-5d4c-4777-9bc0-4513d670b6bc

Thanks, Steve.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 3

Jeff Moden wrote:

Ummm... ok. Why not the best of both worlds instead of "upset everyone"?

If you mean add some relational stuff to the WP document store, I'm tempted. I think some of the enhancements could better use RDBMS structures and query them. Things like tags are a pain now, since they're stored in JSON documents. The devs have resisted, since they want things to look WP-y, for staff changes.

I'm not sold that's a good idea, especially given the lack of ability to solve some issues.

Michael L John One Orange Chip Points: 27079 More actions · Answer 4

Jeff Moden wrote:

Steve Jones - SSC Editor wrote:
I've logged quite a few bugs lately on things. We've got a test site setup for an upgrade to PHP/WP/Nami, which is delaying work on other bugs. The upgrade will allow a forum software upgrade and that may or may not fix something, but no one wants to spend time on something that might be fixed.
I know, I know, the calculation page bug is super annoying. As is the no nav with 16 posts in a thread.
Plus holiday, but plus priorities elsewhere in RG. I ought to learn more about WP, but I find querying the DB maddening, and likely I'd start trying to throw away lots of stuff to make it work more like a RDBMS forum software and upset everyone.
Ummm... ok. Why not the best of both worlds instead of "upset everyone"?

I personally like the "Upset everyone" approach. I say go for it!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 5

It's tempting, really. The downside is the time to learn how WP works and having to write PHP crap to run things.

If I had more experience with it already, I'd be tempted to delete all filed bugs and just manage stuff. I used to do some of that when this was ASP.NET/C#. Just fix things and not tell anyone.

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 6

Steve Jones - SSC Editor wrote:

Jeff Moden wrote:
Ummm... ok. Why not the best of both worlds instead of "upset everyone"?
If you mean add some relational stuff to the WP document store, I'm tempted. I think some of the enhancements could better use RDBMS structures and query them. Things like tags are a pain now, since they're stored in JSON documents. The devs have resisted, since they want things to look WP-y, for staff changes.
I'm not sold that's a good idea, especially given the lack of ability to solve some issues.

Ah... I'm not sure what you originally meant by "upsetting everyone". It thought you were talking about upsetting the users of the site. Now I get the issues you're up against. How "Classic" and totally understood.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Michael L John One Orange Chip Points: 27079 More actions · Answer 7

Steve Jones - SSC Editor wrote:

It's tempting, really. The downside is the time to learn how WP works and having to write PHP crap to run things.
If I had more experience with it already, I'd be tempted to delete all filed bugs and just manage stuff. I used to do some of that when this was ASP.NET/C#. Just fix things and not tell anyone.

For something that is supposed to be intuitive and easy to use, I find Word Press to be cumbersome. I had to work on a web site for a volunteer organization I am a part of that was done in Word Press. The site was an information-only site. There is no database behind it, and aside from a few links to URL's, it's all text and pictures.

It was a lot of swearing and head scratching.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 8

I think WordPress is great for me. I've used it for my blog and for T-SQL Tuesday. A lot of the admin/back end stuff is pretty simple for me, and there are some nice plugins to make things easy to do.

However, developing for it is weird. When I've looked at plugins, the process of building them is weird for me, using a document db approach and lots of looping.

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 9

Steve Jones - SSC Editor wrote:

I think WordPress is great for me. I've used it for my blog and for T-SQL Tuesday. A lot of the admin/back end stuff is pretty simple for me, and there are some nice plugins to make things easy to do.
However, developing for it is weird. When I've looked at plugins, the process of building them is weird for me, using a document db approach and lots of looping.

What language do you have to know to develop for it? PHP?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 10

PHP

https://developer.wordpress.org/plugins/intro/

Lots to think about:

exporting personal data - https://developer.wordpress.org/plugins/privacy/adding-the-personal-data-exporter-to-your-plugin/
new post types - https://developer.wordpress.org/plugins/post-types/registering-custom-post-types/
hooks - https://developer.wordpress.org/plugins/hooks/actions/
security - https://developer.wordpress.org/apis/security/

Plus database tables - https://codex.wordpress.org/Creating_Tables_with_Plugins

In general, it feels like a large uplift to just get started and add something without breaking anything. Plus, we've had a few pieces of forum software over the years, and as you start to make changes for best practices, then you can't upgrade anymore if the vendor patches things or adds features. Essentially you end up forking things in a crazy way.

Our devs do submit patches back to Project Nami (and I think BBPress), but overall, they have to choose to incorporate them, or we face a lot of "re-patches" after upgrades, which sometimes breaks things. I wish that we'd find a way to convince them to adopt some relational techniques for certain parts of this, but the WP model is more document store with lots of JSON.

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 11

Happy new year everyone!

😎

May the source be with you 😉

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 12

Deleted: a bug in the forum caused a duplicate post.

😎

This reply was modified 2 years, 8 months ago by Eirikur Eiriksson.

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 13

Thanks for the links, Steve. I wouldn't even know where to begin any more.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 14

Eirikur Eiriksson wrote:

Happy new year everyone! 😎 May the source be with you 😉

Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing you on the Friday night call this past weekend.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 15

Jeff Moden wrote:

Eirikur Eiriksson wrote:
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing you on the Friday night call this past weekend.

I did too. I hope all is going well for you, Eirikur.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions