Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
3027 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
MySQL data ttype for serialized data
sathishkumars
over 8 years ago
Software: Appian 16.3, on-cloud, MySQL.
Use Case: Store the incoming requests (JSON) of a POST webAPI (asynchronous) in MySQL table' column, which can then be processed later (for example - store the requests in table in business hours and process them out side of business hours, to reduce the load on server at business hours). I am using externalize() and internalize() functions.
Query: What column type should be used to store serialized data in a MySQL db? And what data type should be used in Appian ? I assume, we can use varbinary, blob, text or JSON in MySQL and Text in Appian ? But from Appian's perspective what is considered the best and why ?
OriginalPostID-262593
Discussion posts and replies are publicly visible
0
Stefan Helzle
A Score Level 3
over 8 years ago
Why do you use externalize and internalize? Your incoming JSON already is text which you can store in a text field in DB. Externalized data is text as well and can be stored in a text field.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathishkumars
over 8 years ago
Thanks Stefan, I agree that using externalize(), internalize() might be an overkill for this use-case. But the JSON might have customer sensitive data which may not be appropriate to store in cloud (MySQL), what do you suggest for this ? Base64EncodeDecode Expression plugin ? OR externalize() OR anything else ?
And thanks for the answer, "Text" data type will be appropriate.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 8 years ago
If you are not allowed to store customer data in cloud then Appian in cloud probably might not be the best solution for your use case. Externalize or base64 is NO encryption. Check this plugin:
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathishkumars
over 8 years ago
Thank you Stefan
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 8 years ago
You are welcome :-)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel