Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#16 2020-05-03 20:59:10

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 12,521
Website GitHub

Re: textpattern.com on Hacker news

[Templates and forms in db] needs a response:)

I weighed in earlier on this. And snuck in a link to the article on the dev/live split.

gaekwad wrote #322833:

Far better to make the glue available for a battle-tested SSG to be able to ingest all the pages in a Textpattern and spit out the relevant files for a static site.

+Lots for this.

[Other databases] will be a heap of work to support

If we roll out PDO support, we get a lot of this for free. PHP do the hard work of supporting these databases. Two prominent downsides:

  1. We lose the ability to order by FIELD() natively at the database level because that’s a MySQL extension. Hence nice things like name="services, products, contact" need extra post-processing to reorder in code.
  2. We can’t use IN() because PDO doesn’t natively support parameterized lists as a convenient array – at least didn’t last time I checked the specs; things might have changed in later PHP 7 builds. So we need to add this in at the code level in our PDO layer. We can probably refactor / make more concise versions of our current quote_list/do_list dance to handle this.

Last edited by Bloke (2020-05-03 21:00:20)


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Hire Txp Builders – finely-crafted code, design and Txp

Offline

Board footer

Powered by FluxBB