Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[DISCUSSION] Data schema ¶ separeted values #6

Open
Jatus93 opened this issue Feb 5, 2022 · 1 comment
Open

[DISCUSSION] Data schema ¶ separeted values #6

Jatus93 opened this issue Feb 5, 2022 · 1 comment
Assignees
Labels
pls help Extra attention is needed txt files documents or something why? Further information is requested

Comments

@Jatus93
Copy link

Jatus93 commented Feb 5, 2022

I was thinking to design the data structure like CSV, with ¶ as the separator. (¶SV)
So every entry in the database should be a single string formatted with ¶ to differentiate all the fields.
A basic version of some data should be like this:

  • from the telgram bot we need
chat_id¶user_id¶message_id¶payload
  • to display the data on the application we should use
session_id¶user_id¶payload

Where chat_id and session_id can be tied one to one.

@Jatus93 Jatus93 added pls help Extra attention is needed txt files documents or something why? Further information is requested labels Feb 5, 2022
@Maxelweb
Copy link
Contributor

Maxelweb commented Feb 5, 2022

I was thinking to design the data structure like CSV, with ¶ as the separator. (¶SV) So every entry in the database should be a single string formatted with ¶ to differentiate all the fields. A basic version of some data should be like this:

  • from the telgram bot we need
chat_id¶user_id¶message_id¶payload
  • to display the data on the application we should use
session_id¶user_id¶payload

Where chat_id and session_id can be tied one to one.

Absolutely yes. Unfortunately, we cannot use ¶ as actual file extension, so we can call .psv. But if you want we can use this 🅿️ otherwise.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
pls help Extra attention is needed txt files documents or something why? Further information is requested
Projects
None yet
Development

No branches or pull requests

3 participants