Hello,

AppDrag migrates its one to one support to a general community. We aim to provide high-quality answers available to everyone. After some time we would have a strong questions/answers database bringing a lot of value to our users to build their web applications with confidence. We also want to create a dynamic community to improve the platform and our reactivity to build and fix things based on what you as website builders really need.

Here are the 3 main rules to respect when asking a support question on the board:

• Don’t post until you’ve searched the Community for the answer first

• When posting, provide as much information as possible so that your problem can be fully and clearly understood. You can include an appID, link, screenshot, detailed description, etc.

• Be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

Don’t forget that if you want somebody else to consult on or develop your AppDrag solution for you, we can provide you with paid support or connect you with one of our certified partners.

Hey Pierre,

your issue is coming from "-" in table name ... it's a forbidden character with MySQL ...
Internally we do have a trick to be able to use it but it's really not recommended ... you will have to backtick the table name everywhere in your queries because of this...

My advice, follow best pratices a just don't use forbidden characters in your table names

Hey dear community,
We worked hard to improve appdrag documentation with more content, use cases and a better search engine (full-text with scoring)
There is now 147 articles including 14 use cases tutorials

You can check it here: https://support.appdrag.com/

Hey dear community,

We have updated our appdrag-cloudbackend NPM package to allow parametrized SQL queries.

If you want to compose the SQL query by yourself with input parameters you must escape the user inputs to avoid SQL injection with cloudbackend.escape() like this:

cloudbackend.sqlSelect("SELECT * FROM Products WHERE category = '" + cloudbackend.escape( event.POST.category ) + "'")
.then( function(response) {
	console.log(response);
});

But there is now a better way with parametrized queries, You can use ? characters as placeholders for values you would like to have escaped. Multiple placeholders are mapped to values in the same order as passed.

cloudbackend.sqlSelect('SELECT * FROM Products WHERE category = ? and id > ?', ["Software", 500])
.then( function(response) {
	console.log(response);
});

You can check the full documentation on NPM:
https://www.npmjs.com/package/appdrag-cloudbackend

Hey Thomas, indeed great idea!
I have just added the new section "How-to, Tutorials"

Hey Daniel,

since we use AWS Lambda under the hood, we are waiting for AWS to add it and we will get it the same day on AppDrag Cloudbackend

You can check this page for more details about supported Node.js versions:
https://docs.aws.amazon.com/lambda/latest/dg/lambda-nodejs.html

Based on the latest update for Node 12, (https://aws.amazon.com/blogs/compute/node-js-12-x-runtime-now-available-in-aws-lambda/)
There is a 6-7 months delay between on official LTS release of node and it's availability on AWS Lambda

I can see you have a script on the page that is crashing ...
and it's making crash the render of the page

Please try to remove your custom script (or fix it)

Also, instead of placing scripts directly in the source code of your page or in the head of the page, place it in a block of code, this way it will be safe

Hey Community, we are happy to announce that our CLI tool is now available on NPM
https://www.npmjs.com/package/appdrag

deploy your full-stack apps to the cloud. Work with your local tools (VS Code, Atom, ...) and build process, then push your compiled code to your app in appdrag

This tool is recommended for:

• Develop locally with your usual tools (VS Code, Atom, ...) and build process (Webpack, ...)
• Setup a CI/CD pipeline
• Setup an external backup of your app
• Export/Import full-stack projects

In that case DO NOT USE the option 404 if no result because this is linked to 404 page (as it name says :p)
and then handle in JS the situation with few 2 lines of JS, like if the fields are empty ... redirect to page X ...

Hey Franck,
yes it's possible, when you configure your scheduling select "Every-week" in the recurrence type dropdown
you can then indicate the days of the week and hour

Hey Mark,
please check our documentation on how to hide/show pages in the menu:
https://support.appdrag.com/doc/Hide-and-show-a-page

The menu bar is global to your project, but you can decide per page to use or not the global header/footer
https://support.appdrag.com/doc/Header-and-Footer

@Pablo-Garcia here could you provide your full SQL query and code? probably your code is calling an SQL query ... but since you didn't provided anything we can only guess

also your partial syntax seems wrong

It should be:

SELECT * FROM Table WHERE column_name != 'YOUR_VALUE' AND column_name IS NOT NULL;

Hey Kodi,
could you try to reactivate SSL from your project options > Main Domain & SSL?

easiest solution is to remove it and add it again with the correct value

Hey Thomas,
The amount of data you can return with a lamda is 5MB

So I guess the error is in your code, you should publish your source code for more details

Hey Linda, OpenVM is a bit out of topic here (cloudbackend)
We plan to open a new community for OpenVM soon

You might check the STRAPI quickstart guide here:
https://strapi.io/documentation/developer-docs/latest/getting-started/quick-start.html#_8-publish-the-content

When you are in VS Code, in the left panel you must click on open folder and select the folder where you have deployed you files, or the default path "/opt/app/strapi/"

You can also open a Terminal in the left menu, this way you can run any commands indicated in Strapi documentation

Hey Linda,
In that case you use directly the Strapi template (available in the list)
once the VM is ready, click on the cogs icon, then click on "File Explorer"
From there navigate to /opt/app/strapi ... and place your files there

FYI I'm not an expert on Strapi so probably their community will be able to better assist you on that
I know there is also a lot of tutorials available about strapi

OK so I have investigated a bit more SupaBase ... unfortunately there is no WEB UI in the opensource version ... it's just the regular Postgres + few plugins preloaded ... so for now it won't be included, this might change if later they add a web UI in the open source version

Hey dear community,

We have updated our appdrag-cloudbackend NPM package to allow parametrized SQL queries.

If you want to compose the SQL query by yourself with input parameters you must escape the user inputs to avoid SQL injection with cloudbackend.escape() like this:

cloudbackend.sqlSelect("SELECT * FROM Products WHERE category = '" + cloudbackend.escape( event.POST.category ) + "'")
.then( function(response) {
	console.log(response);
});

But there is now a better way with parametrized queries, You can use ? characters as placeholders for values you would like to have escaped. Multiple placeholders are mapped to values in the same order as passed.

cloudbackend.sqlSelect('SELECT * FROM Products WHERE category = ? and id > ?', ["Software", 500])
.then( function(response) {
	console.log(response);
});

You can check the full documentation on NPM:
https://www.npmjs.com/package/appdrag-cloudbackend

@Linda-MacDonald Definitely, it's in the roadmap for next 2 weeks