Text only | Text with Images

Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: Shkic on June 27, 2017, 09:35:46 AM

Title: List Of Compatible Mods with 2.1
Post by: Shkic on June 27, 2017, 09:35:46 AM
Below is list of compatible mods with SMF 2.1 (even if description says that mod is not compatible with 2.1):

Redirector  https://github.com/realdigger/SMF-Redirector/releases
MathJax https://github.com/realdigger/SMF-MathJax-Mod/releases
Code Syntax Highlighter https://github.com/realdigger/SMF-SyntaxHighlighter/releases
YouTube Embed http://custom.simplemachines.org/mods/index.php?mod=3268
Personalized BBC http://custom.simplemachines.org/mods/index.php?mod=3864
Expanding & Collapsing Spoiler Tag http://custom.simplemachines.org/mods/index.php?mod=3981
EhPortal http://web-develop.ca/index.php?action=downloads;sa=view;down=3
PortaMx Virgo 2.0  https://github.com/PortaMx/PortaMx-Virgo-2.0-Beta-3
Hide Topics from Guests http://custom.simplemachines.org/mods/index.php?mod=2380
Apache Error Handler  http://custom.simplemachines.org/mods/index.php?mod=1363
Watermark.light https://github.com/realdigger/SMF-Watermark-Light/releases

Knew more? Share.
Title: Re: List Of Compatible Mods with 2.1
Post by: shawnb61 on June 30, 2017, 01:34:17 AM
The two most important mods for my forum are already available & work OK:
   SAVE - Simple Audio Video Embedder
   Download System
Title: Re: List Of Compatible Mods with 2.1
Post by: dougiefresh on July 05, 2017, 10:10:43 PM
As of this moment, the following mods from my mod list (http://custom.simplemachines.org/mods/index.php?action=search;author=253913) are compatible with 2.1 Beta 3 (in order of creation):

The rest of them are in the process of being upgraded to work with 2.1 Beta 3, but should work on 2.1 Beta 2 just fine....  Once I'm finished updating the remaining mods, I'll post the rest of the list....
Title: Re: List Of Compatible Mods with 2.1
Post by: albertlast on July 05, 2017, 11:43:23 PM
Well I looked in some mods (not all),
but from PostgreSQL side not all mods works for smf 2.1.

Commen issues:
Not using smf db api for creating/changing table
Using IFNULL instead of COALESCE (which you should use because this function allow an unlimited amount of col)
    also notice that smf2.1 project didn't use ifnull any more
Using backticks `

Since the pg support is part of smf 2.1, i would see that "Compatible with smf 2.1" is a bit misleading.

Also a warning in the github version (called beta 4 actualy) we changed the sql_mode to strict mode
look at "Alignment of mysql sql mode..." @ http://wiki.simplemachines.org/smf/Differences_between_SMF_2.1_and_SMF_2.0#New.2Fimproved_features_for_mod_authors
Title: Re: List Of Compatible Mods with 2.1
Post by: shawnb61 on July 06, 2017, 03:38:03 PM
I think mods should explicitly indicate pg and/or mysql support.

I'd be pretty upset if I went the pg route only to find that 75% of the mods don't work...  Especially if the only way to find out is by trial & error. 
Title: Re: List Of Compatible Mods with 2.1
Post by: vbgamer45 on July 06, 2017, 03:39:20 PM
It's hard for a mod developer to test two different db systems twice the work. I know none of my mods support pg if they use database mainly do to the create tables i prefer the raw sql for porting purposes/debugging.
Title: Re: List Of Compatible Mods with 2.1
Post by: shawnb61 on July 06, 2017, 03:44:20 PM
In general, if you use smcFunc & keep the sql simple (i.e., ANSI... when in doubt, Google it...), you will automatically support both pg & mysql.  It's not hard at all. 

I'll be honest, I'm kinda shocked that SMF "supports" pg, yet doesn't have that as a check in mod approval. 
Title: Re: List Of Compatible Mods with 2.1
Post by: Arantor on July 06, 2017, 03:48:40 PM
Yes, but if you have a mod that comes from SMF 1.1 days, before $smcFunc existed... that's a legitimate concern. Not to mention if you're like me and were writing mods during 2.0's RC phase where the behaviour of $smcFunc broke in very subtle but massively frustrating ways for mod authors.

Or if you're me and you do DB specific optimisations (ORDER BY NULL is a frequent offender because it's syntactically different in PG), or you need specific operating characteristics (e.g. forcing MyISAM tables so you can build specific indexes)

But in general PG support isn't that hard, it's just usually untested because so few people use it. It's mostly there because about ten years ago everyone thought PG would replace My as the dominant DB system.
Title: Re: List Of Compatible Mods with 2.1
Post by: shawnb61 on July 06, 2017, 07:41:03 PM
In that case, a simple Postgresql Support:  Yes, No, or Unverified will work.   Just don't make folks experiment...
Title: Re: List Of Compatible Mods with 2.1
Post by: Arantor on July 07, 2017, 02:10:59 AM
For the number of PG users, though, it's simply not worth the effort.
Title: Re: List Of Compatible Mods with 2.1
Post by: albertlast on July 07, 2017, 09:48:57 AM
What is the effort,
to notice on addon what the pg status is? (Yes, No, or Unverified)

the db specific optimisations harm your self because they can change between mysql version,
like you example about order by null: http://www.tocker.ca/2013/10/21/heads-up-implicit-sorting-by-group-by-is-deprecated-in-mysql-5-6.html
Title: Re: List Of Compatible Mods with 2.1
Post by: Arantor on July 07, 2017, 09:59:23 AM
This is something you have to track, which means modifying the mod site to support it.

For a feature that in the last 6 years since SMF2.0 went gold still has single digits' worth of current users. It might possibly have broken double digits, but I strongly doubt it. The 2.0 PG and SQLite board, on page one goes back to 2013, with no topics in 2017, 2 topics with posts from 2016, 4 topics from 2015... and it looks like a non trivial percentage of those are SQLite. It honestly feels like it isn't worth the effort except for the tiny handful of people who would benefit for which I'd argue there are better uses of peoples' time.

And assuming this was done, every single mod will be unverified until people do something about it, and historically people just don't bother.

Notice how many people signed up to test 2.1 on PG... it feels like there would be better time spent making SMF work correctly on modern MariaDB than on PG.
Title: Re: List Of Compatible Mods with 2.1
Post by: albertlast on July 07, 2017, 01:00:00 PM
maria db is on the same worst level as mysql ( i know this because my dev env use pg and mariadb),
the next release get better with window function and cte.

that the numbers are low for smf 2.0 for many reason,
- support tell the user to use mysql
- postgresql doesn't work so well on 2.0 (reason why support recommand to use mysql)
- mod support is bad

but with 2.1
- pg run faster as mysql (tested by benchmark)
- got a better integration (exp. use native fulltext search)

btw cte exists since 1999 and "modern db like mariadb" didn't support this...
Title: Re: List Of Compatible Mods with 2.1
Post by: Arantor on July 07, 2017, 01:17:14 PM
Yes, but the majority of 2.1 users are going to be coming from 2.0 and even if the team turned around and said tomorrow, unilaterally, 'we recommend Postgres for 2.1' (which won't happen), the majority of users still won't touch it because the vast majority of the userbase is on hosting that is MySQL-first and frequently MySQL-only (whether that's vanilla MySQL or MariaDB)

Yes, I know PostgreSQL is technically better. I'm aware of that. I do insane things with databases (currently in the middle of rewriting a reporting system that can easily push 2-3 MILLION queries at a single database server over the course of a few hours, though CTEs wouldn't help with that)

The reality is that you can push for it - and I could push for it, but from the code level it's still not a first class citizen even with all the work done in 2.1 thus far, and it's not going to be a first class citizen in 2.1. It's close, but it's still not there, and modders are wary of putting in any more than the basic work required - a lot of modders kept avoiding $smcFunc for a long time. Lots still do.

So encouraging PostgreSQL discourages the third party people. Sucks, but that's the way this community works.
Title: Re: List Of Compatible Mods with 2.1
Post by: dougiefresh on July 11, 2017, 10:43:40 AM
If you find a mod that doesn't work with Postgres, post in that mod's thread.  If the thread is mine, I will see what I can do about making it more compatible.  If it isn't, maybe the author will...

Ya never know until you ask...
Title: Re: List Of Compatible Mods with 2.1
Post by: albertlast on July 11, 2017, 11:19:44 AM
Well you use in some mods "IFNULL" that could be replace with "COALESCE".
For other stuff i had to look more deeper into this.
Title: Re: List Of Compatible Mods with 2.1
Post by: dougiefresh on July 11, 2017, 12:10:03 PM
Quote from: albertlast on July 11, 2017, 11:19:44 AM
Well you use in some mods "IFNULL" that could be replace with "COALESCE".
For other stuff i had to look more deeper into this.
I've replaced all occurances of "IFULL" with "COALESCE" in my mods.  Thank you!
Title: Re: List Of Compatible Mods with 2.1
Post by: simplengmakina on March 15, 2019, 12:56:28 PM
Is there an updated list?
Title: Re: List Of Compatible Mods with 2.1
Post by: Antes on March 15, 2019, 01:03:25 PM
https://custom.simplemachines.org/mods/index.php?action=search;smf_versions=92 - this should give you the idea. There might be some more mods working fine with SMF 2.1 but best stick to the mods listed under link I posted.
Title: Re: List Of Compatible Mods with 2.1
Post by: Oldiesmann on March 18, 2019, 03:30:11 PM
For portals, there's also a 2.1-compatible fork of SimplePortal at https://web-develop.ca/
Title: Re: List Of Compatible Mods with 2.1
Post by: lurkalot on March 18, 2019, 03:50:24 PM
And obviously TinyPortal is also 2.1 compatible.

https://custom.simplemachines.org/mods/index.php?mod=97
https://www.tinyportal.net/index.php?action=tpmod;dl=item129

My 2.1 test site https://cctestsite.info/testsite3/
Text only | Text with Images