Cloud Backend (Cloud DB, API Builder)

• 

  How to increase results in Visual Sql Select
  • Marc Lamouret  

  2
  0
  Votes
  2
  Posts
  5
  Views

  

  Hi Marc, wish you're fine! On Visual SQL Select if you look at the documentation there are those parameters to determine the page size and page number to avoid people to fetch too many rows when it's not needed. If you really need to fetch more results: Set the pageSize to a higher value Use Raw SQL Select
• 

  Node v.14 and/or ES2020
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  7
  Views

  

  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
• G

  Where is the data hosted? EU or USA?
  • Gerson Kramer  

  5
  0
  Votes
  5
  Posts
  19
  Views

  

  Hey Gerson, I can confirm that all the data on AppDrag is stored only in EU (AWS EU-WEST-1, in Dublin, Ireland)
• T

  Admin VS front-end input inconsistencies...
  • ThomasD  

  5
  1
  Votes
  5
  Posts
  20
  Views

  T

  @Wassim said in Admin VS front-end input inconsistencies...: JSON.stringify($("select[name='searchableList']").val()) Thanks a lot for the workaround, works as expected! Plus gave me some new ideas, neat the we can do formulas there, didn't even notice! I love that there are these hidden gems in Appdrag
• 

  [TM] Importing CSV
  • Pierre SULPICE  

  5
  0
  Votes
  5
  Posts
  14
  Views

  

  That was so obvious... I don't know why I was going that far.... thanks a lot !
• 

  [TM] Cloud DB UI - Pagination issue
  • Pierre SULPICE  

  4
  0
  Votes
  4
  Posts
  24
  Views

  

  Hello, Sorry for the late reply, it works like a charm, thanks See you soon,
• T

  Retrieve visitor country code?
  • ThomasD  

  6
  0
  Votes
  6
  Posts
  23
  Views

  

  Can you help me understand the use-case a bit more? Maybe I'll get a flash of inspiration if I know more about what you're trying to do
• L

  is there a way to connect to the database when developing locally?
  • Linda MacDonald  

  9
  0
  Votes
  9
  Posts
  29
  Views

  L

  @Daniel-Mulroy thank you so much for this🤩...hope it didnt disturb your work flow you're in luck, am on windows so once I get up and running I'll let you know
• L

  the cli takes my whole rootfolder to be a file
  • Linda MacDonald  

  3
  0
  Votes
  3
  Posts
  9
  Views

  L

  hey there @Daniel-Mulroy I took another look at it and as it turned out I did have a zip file which I uploaded...the app is running on appdrag but for sure I'll try the / at the end next time cause it was rather peculiar error message and even more peculiar since it did what it was meant to do
• L

  how do I switch back to that pretty cards preview on the template db folder?
  • Linda MacDonald  

  3
  0
  Votes
  3
  Posts
  10
  Views

  L

  @Daniel-Mulroy you're pure magician!! - I've gotten it back!!! thanks a mil
• 

  How to save uploaded file in Custom Folder ?
  • vinoth kumar  

  3
  0
  Votes
  3
  Posts
  17
  Views

  

  @Joseph-Benguira Thanks Joseph. Also i have another doubt. What's the max file size we can upload in CloudBackEnd ? I tried to upload a file size of 55 mb. It doesn't worked.
• L

  how to implement a node/vue js app?
  • Linda MacDonald  

  11
  0
  Votes
  11
  Posts
  61
  Views

  

  Here is the link to our CLI tool: https://www.npmjs.com/package/appdrag
• 

  How to use Foreign Key concept ?
  • vinoth kumar  

  3
  0
  Votes
  3
  Posts
  17
  Views

  

  @Joseph-Benguira, Thanks. Will give a try.
• L

  how to add longditude/langditude to DB - float?
  • Linda MacDonald  

  8
  1
  Votes
  8
  Posts
  31
  Views

  L

  @Joseph-Benguira yup atlas is cool, was just wondering if you where considering getting it into the appdrag ecosystem
• 

  [TM] Private code
  • Pierre SULPICE  

  5
  0
  Votes
  5
  Posts
  23
  Views

  

  Well it's not THAT sensitive indeed, it was more like macros for table names and preprod names and stuff like that to avoid to repeat it and be able to change it easily. I know the Database and stuff like that are protected but I'm thinking that it's still the bed idea to spread all the accurate name of everything that easily ^^" Problem with the Env Variables is that they are contained only in the func where I write them, so it's not helping that much for this specific usage. I don't really like the idea of having an API call "just for that", especially when I'll use it a lot for my tracking system, the goal is more to reduce them So it's not an ABSOLUTE NEED but it might be very handy to add some genericity in my code. For now I'll not do it, I'll let you know if I come up with a cool system to do it painlessly See you soon,
• 

  High Volume Email sending - rate limiting? Queueing?
  • Daniel Mulroy  

  8
  2
  Votes
  8
  Posts
  43
  Views

  

  In fact we have a much larger allowance on AWS SES (few hundreds per sec) and it's shared by all appdrag customers. I'll check but I don't think we have any hard limit per user on our side.
• 

  [TM] Broken Database
  • Pierre SULPICE  

  8
  0
  Votes
  8
  Posts
  27
  Views

  

  Oops, I misunderstood!
• 

  Protected External link to Cloud DB
  • Pierre SULPICE  

  4
  0
  Votes
  4
  Posts
  19
  Views

  

  @Wassim Thanks for the reply ! I think it's not useful enough to ask for the new feature directly, but for exemple I have inscriptions I would like to share dynamically to someone that doesn't have an AppDrag account and it's painful to make him create one in his situation ^^" The only solution I then have is an open link, but it's kind of sensitive so it's not the best to "open" it. I can extract them regularly ofc but it's less dynamic all of a sudden ^^" Thanks for your answer anyway !
• 

  Email with attachments
  • vinoth kumar  

  4
  0
  Votes
  4
  Posts
  27
  Views

  

  Perfect !
• T

  This topic is deleted!
  • ThomasD  

  6
  0
  Votes
  6
  Posts
  8
  Views
• T

  Ran out of API calls per minute, but no one's using it...
  • ThomasD  

  15
  0
  Votes
  15
  Posts
  24
  Views

  T

  @Wassim Thanks it all makes sense now. I was about to use the Starter Tier for our use-cases, since I think that's the minimum required and also use 1 minute cache. I'll probably make a calculator for back-end, so I don't lock myself into unnecessary billings, maybe it could be useful for the community too.
• 

  Stripe Button not appear
  • Katya Nakache  

  19
  0
  Votes
  19
  Posts
  33
  Views

  

  Thank you ! yes I had to redo it and after that it worked alone
• T

  XSS & SQL Injection?
  • ThomasD  

  4
  0
  Votes
  4
  Posts
  25
  Views

  

  I'd like to share another method which is less error prone : function escapeSQL(strings, ...vars) { return vars.reduce((str, v, i) => { if (typeof(v) == 'string') { return str + v.replace(/'/g, "''") + strings[i+1]; } else { return str + v + strings[i+1]; } }, strings[0]); } var myParam = event.POST.myParam; var myParam2 = event.POST.myParam2; var query = escapeSQL`SELECT * FROM MyTable WHERE myColumn='${myParam }' AND mySecondColumn='${myParam2 }'` This way your query won't be extra long as you don't have to call a function for each parameter
• T

  Pass current Appdrag admin user name to API?
  • ThomasD  

  11
  0
  Votes
  11
  Posts
  27
  Views

  T

  @Joseph-Benguira Yeah, in the recent versions of TLS it does encrypt it fully. However, DNS might leak it since encrypted DNS resolution isn't that much of a standard yet. And browsers will still save the token in browser history. If it's overkill to encrypt it properly, maybe, but it's an additional protection against 3rd party attacks, since no one can just take the token (from a browser) and send it without the shared secret.
• T

  API calls per minute
  • ThomasD  

  5
  0
  Votes
  5
  Posts
  18
  Views

  

  @Daniel-Mulroy yes, @Joseph-Benguira meant Request Per Minutes. It hurts for the king of high RPS infrastructures to switch to speak about RPM instead of RPS
• T

  Trigger resource manager manually?
  • ThomasD  

  4
  0
  Votes
  4
  Posts
  13
  Views

  T

  Though, conceptually it's quite easy. Add custom link to menu in admin When link is clicked, it opens an iframe URL in a modular window. The URL contains an encrypted payload in the URL parameter. The receiving back-end then decrypt the payload using a secret key. The payload contains basic JSON that contains a session key. The session key can be verified by POSTin to an Appdrag Endpoint to verify it's still valid (encrypted payload here too). Since we're encrypting the payload using a secret, no man-in-the-middle can temper with the content and since we're posting only a current session key, the session lifetime can be limited and verified even on the back-end side. Not what I had in mind for the asset manager though. Update: You're right, for it to be usable it would need to be it's own library and you'd need to make "custom apps" as mentioned above, available, which I expect you don't have plans for.
• 

  [Bug] CloudDB -> Sharing with Edit permissions, unable to add row
  • Daniel Mulroy  

  2
  2
  Votes
  2
  Posts
  12
  Views

  

  Hey Daniel, Thank you for reporting it, the issue has been fixed and will be live today with many small improvements on AppDrag platform
• 

  CloudBackEnd DownloadFile
  • vinoth kumar  

  2
  0
  Votes
  2
  Posts
  14
  Views

  

  Instead of calling the download with fetch, from the client side just make a A Link pointing to the url of your cloud function You can also check our NodeJS samples to return a binary file
• 

  Python data retrieval
  • vinoth kumar  

  6
  0
  Votes
  6
  Posts
  26
  Views

  

  @Joseph-Benguira said in Python data retrieval: https://api.appdrag.com/CloudBackend.aspx Thanks team. Will definitely give a try.
• 

  Python connecting with DB
  • vinoth kumar  

  2
  0
  Votes
  2
  Posts
  9
  Views

  

  Hi, Why posting the same answered question again? https://community.appdrag.com/topic/211/python-data-retrieval
• 

  Advanced SQL Field Types
  • Daniel Mulroy  

  15
  0
  Votes
  15
  Posts
  49
  Views

  

  You can run the in "New Query", this is returning the execution time in miliseconds of your query Another great thing you can do to improve query speed is to add indexes on your tables on the fields you are using in WHERE or JOIN conditions. You can get a 100x improvement with indexes It's accessible from the EDIT button when you are inside a table
• 

  [TM] Regex email validation
  • Pierre SULPICE  

  2
  0
  Votes
  2
  Posts
  12
  Views

  

  Hey, sure : function validateEmail(email) { var re = /^(([^<>()[]\\.,;:\s@"]+(\.[^<>()[]\\.,;:\s@"]+)*)|(".+"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/; return re.test(email); }
• 

  [TM] LAST_INSERT_ID not working
  • Pierre SULPICE  

  2
  0
  Votes
  2
  Posts
  10
  Views

  

  Hey Pierre, This must be done in the same transaction, please check this tutorial about it: https://support.appdrag.com/blog/63-Inserting-a-Row-in-the-Database--Create-New-Row-Id.html?category=13
• 

  [TM] TSV exporter
  • Pierre SULPICE  

  2
  0
  Votes
  2
  Posts
  7
  Views

  

  Little temporary hotfix : JSON.stringify(actionUp).replace(/,/g, '|') to store it JSON.parse(prq_visitor.actions_list.replace(/|/g, ',')) to use it That's annoying but I have a clean usable CSV, and it's easy to ctrl+H in the JSON column to replace the | by , Still waiting for an update for a better way to do it ^^ See you soon, Best regards,
• T

  SOLVED Back-end repeated columns?
  • ThomasD  

  2
  0
  Votes
  2
  Posts
  10
  Views

  T

  I solved it by using custom CSS and Grid I'll make a request to add this to the builder.
• B

  I can't c
  • Bianca Duboisset  

  2
  0
  Votes
  2
  Posts
  7
  Views

  

  It seems you try to display a details page like in this tutorial: https://academy.appdrag.com/FullStack-with-cloud-backend-Episode-5.html But it also seems you forgot to pass the parameter to your details page like explained in the tutorial So since no param is passed variables are not replaced test this link: http://www.ohmyband.fr/Description.html?id=2
• T

  SOLVED What is AI, PK, UQ when creating new column?
  • ThomasD  

  6
  0
  Votes
  6
  Posts
  31
  Views

  

  Is this a conspiracy?
• T

  How to check if user is logged in to admin using back-end function?
  • ThomasD  

  4
  0
  Votes
  4
  Posts
  26
  Views

  

  We don't have this feature yet, feel free to post it in "Features Request" section with details about what you want and how you would like to have it / use it For now you have to invite users by email through your White Label dashboard, so they will receive credentials by email with your branding
• T

  How to upload several images?
  • ThomasD  

  5
  0
  Votes
  5
  Posts
  27
  Views

  T

  @wassim Would appreciate it if you could add it to the native table viewer or you'll keep getting this question over and over.
• R

  setting payload response variables
  • Robert Chura  

  2
  0
  Votes
  2
  Posts
  22
  Views

  

  Hi Robert, Can you provide a bit more information, like what language you are using for your CloudBackend function? if it's Node.js, try using: callback(null, variable_for_payload) If Python, you can try simply: return variable_for_payload