Cloud Backend (Cloud DB, API Builder)

• L

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

  2
  0
  Votes
  2
  Posts
  3
  Views

  

  Hey @Linda-MacDonald I agree, the CloudDB feature is AMAZING! You can't switch an existing view to/from card view... you have to create a card view for your data.... then you can switch TO that view. Does that make sense? You've probably already done this if you saw your data as cards already. Click the binoculars in the upper left corner, and card type views are shown by this little icon If you don't see one, create a view for it using the option at the bottom of the drop-down. Cheers!
• 

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

  3
  0
  Votes
  3
  Posts
  19
  Views

  

  Hi @Pierre-SULPICE, we now export all pages at once whatever page you're on.
• 

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

  3
  0
  Votes
  3
  Posts
  16
  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
  58
  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
  16
  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
  20
  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
  41
  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
  26
  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
  25
  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
  22
  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
  32
  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
  18
  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
  26
  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
  16
  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
  12
  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
  11
  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
  13
  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
  46
  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
  30
  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
  25
  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
  26
  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
• M

  Additional elements in Header, Desktop vs. Mobile
  • Meir Sabbah  

  2
  0
  Votes
  2
  Posts
  18
  Views

  

  Hey Meir, Since you want to change the behavior of the mobile menu you have to do this with a block of JS script There you can add/modify with code your mobile menu Kind regards
• 

  Default Timezone
  • Pierre SULPICE  

  3
  0
  Votes
  3
  Posts
  11
  Views

  

  Ok I'll go with that, thanks !
• 

  Production version of API and scheduling
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  17
  Views

  

  Hello Daniel, Yes, it triggers the production version from your function.
• R

  This topic is deleted!
  • Robert Chura  

  1
  0
  Votes
  1
  Posts
  12
  Views

  No one has replied

• 

  Download nightly backups of individual tables?
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  14
  Views

  

  Hey Daniel, unfortunately it's not possible and would not be practical and efficient for us to do backups at table level instead of DB level. What we usually do to restore just one table from a backup: restore the backup (either locally on your computer or in a new project on AppDrag) export in CSV the table you are interested in Clear the table you want to restore (to make it empty before the restore, use the Clear command we have on the table in cloudbackend) import the CSV of your table Done
• K

  Can I leverage socket.io via the API Builder or Page builder?
  • Konrad Hylton  

  3
  0
  Votes
  3
  Posts
  18
  Views

  K

  @Joseph-Benguira Thanks, Joseph! I'll look into those links and play around with them in the meanwhile.
• J

  This topic is deleted!
  • John Lamb  

  2
  0
  Votes
  2
  Posts
  7
  Views
• J

  Date Functions?
  • John Lamb  

  4
  0
  Votes
  4
  Posts
  10
  Views

  

  In VisualSQL, Formulas can be user in WHERE conditions ... not to format the selected data and the output ... you can do that only in Raw SQL