Cloud Backend (Cloud DB, API Builder)

• K

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

  4
  0
  Votes
  4
  Posts
  22
  Views

  

  Bumping this up, @Joseph-Benguira any progress on this? I'm starting to have use cases for socket.io piling up If not sockets.io, is something like this https://www.serverless.com/blog/realtime-updates-using-lambda-websockets-iot compatible with PageBuilder/CloudBackend?
• 

  [Bug] - can't share more than one CloudDB folder with an external email address?
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  9
  Views

  

  Hello, Exactly, thanks to you for finding this issue! This has been corrected, it will be live tomorrow.
• L

  how do we install node packages? + how to save app credentials in the env section
  • Linda MacDonald  

  6
  0
  Votes
  6
  Posts
  18
  Views

  

  Hey, yes you can call it whatever you want as they are just variable names. You just have to use the same name when using process.env.yourVariable. Your code will use the computed value of it so the name has no impact. (unless a library specifically use inside its code process.env.whateverVariable)
• 

  [Urgent] Mailing by API
  • Pierre SULPICE  

  15
  0
  Votes
  15
  Posts
  41
  Views

  J

  Hey Pierre, please ensure the email sender address configured in your whitelabel settings is validated or else indeed no emails will be sent Another option is to clear the sender email address field in your whitelabel settings
• S

  Creating front end links
  • Stephen Bower  

  1
  0
  Votes
  1
  Posts
  6
  Views

  No one has replied

• T

  Retrieve visitor country code?
  • ThomasD  

  9
  0
  Votes
  9
  Posts
  36
  Views

  T

  @Wassim Super, then I don't need to worry about that
• 

  How do I store a file with GOOGLE_APPLICATION_CREDENTIALS needed for Firebase Auth?
  • Ugnius Ramanauskas  

  2
  0
  Votes
  2
  Posts
  10
  Views

  

  Hey Ugnius, in the env variable settings, add a new env var, name it "googleJSON" for eg. but you can name it as you want on the right side, as value, paste the whole text content of the json file you have from google. var googleJSON = JSON.parse(process.env.googleJSON); admin.initializeApp({ credential: admin.credential.cert({ projectId: googleJSON.project_id, clientEmail: googleJSON.client_email, privateKey: googleJSON.private_key }), databaseURL: "https://<DATABASE_NAME>.firebaseio.com" }); Just a small thing, whenever you can you should avoid Google! Google deprecates API and services every week and providing nearly zero warning to "customers", in fact they have no respect at all for developers using their services and it's nearly impossible to talk with someone there. So if you want your service to be down in the next 6 months because it's deprecated without any notice ... sure go with google
• T

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

  8
  1
  Votes
  8
  Posts
  35
  Views

  T

  @Wassim Wonderful, thanks!
• 

  Table Column Default Value
  • Dick Honing  

  3
  0
  Votes
  3
  Posts
  9
  Views

  

  I have been wishing for this. @Wassim Would it be possible to choose to use an integer or a UUID for the default 'id' / index column?
• 

  How to increase results in Visual Sql Select
  • Marc Lamouret  

  2
  0
  Votes
  2
  Posts
  8
  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
  9
  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
  22
  Views

  

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

  [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,
• L

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

  9
  0
  Votes
  9
  Posts
  30
  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
  19
  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
  64
  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
  33
  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
  24
  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
  20
  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
  27
  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
  37
  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
  27
  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
  28
  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
  19
  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
  27
  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
  10
  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
  53
  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
  11
  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