Inquiry about some stuff
-
@jeffreyrb03-gmail I just need some ideas on how to implement it, not 100% sure on my logistics plan with this
edit: also we have to use google sheets if we do go through with this because my home wifi doesn’t allow website hosting (looked it up to verify I wasn’t being stupid with the port forwarding not working) so I don’t think using fetch webpage as markdown (and chanigng like an unused parameter url so it doesn’t cache) would work unless you can use that not to send the delayed fetches (creaticode said it lets page content load)
-
@jeffreyrb03-gmail all my plans involve self hosting on my laptop (its how I hosted my discord bots), wher eI use the google api (already used to download files to google drive, don’t ask I went insane trying to) to constantly read a google sheet for changes (or set a handler) and run some stuff when somebody writes to a sheet, which automatically formats the message data into another sheet which all clients can read (but the project isn’t shared), also you can’t write formulas to a google sheet, trying to prefix anyhting with = when writing a table will put ’ infront of it in the google sheet
@tyller_ since formulas don’t work with the blocks in GS, just use an API. Like if you need cube root then fetch a url like example.com/cuberoot?n=8. The same applies to your messaging system but im not sure.
#LLJW
<span style="color:white;background-image:linear-gradient(to right, lightblue, navy)">My name is Jeff</span> -
@tyller_ since formulas don’t work with the blocks in GS, just use an API. Like if you need cube root then fetch a url like example.com/cuberoot?n=8. The same applies to your messaging system but im not sure.
@jeffreyrb03-gmail I host things on glitch so when I have the time I could prolly make an API for you
#LLJW
<span style="color:white;background-image:linear-gradient(to right, lightblue, navy)">My name is Jeff</span> -
@jeffreyrb03-gmail I host things on glitch so when I have the time I could prolly make an API for you
@jeffreyrb03-gmail Im going to try using google apps scripts, currently I’m attempting to find the rate limits but am unable to find the free rate limits for any of it
<div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
</div> -
@jeffreyrb03-gmail Im going to try using google apps scripts, currently I’m attempting to find the rate limits but am unable to find the free rate limits for any of it
@tyller_ Ok. You say this is to “make message storage easier” but idk this looks like a lot more errors and work are gonna come out of this than if you just used a different method like perhaps a queue system where messages are stored in a database (in creaticode) and then pushed gradually over to google sheets and retrieved when needed like for saving chats like a discord like app
#LLJW
<span style="color:white;background-image:linear-gradient(to right, lightblue, navy)">My name is Jeff</span> -
@tyller_ Ok. You say this is to “make message storage easier” but idk this looks like a lot more errors and work are gonna come out of this than if you just used a different method like perhaps a queue system where messages are stored in a database (in creaticode) and then pushed gradually over to google sheets and retrieved when needed like for saving chats like a discord like app
@jeffreyrb03-gmail that does seem like a much better idea, but whats the limit on the database row count, I’d asusme it’d be about the semantic or knn limit (100 for regular users 200 for premium, I was reading docs and scrolled over it)
<div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
</div> -
@jeffreyrb03-gmail that does seem like a much better idea, but whats the limit on the database row count, I’d asusme it’d be about the semantic or knn limit (100 for regular users 200 for premium, I was reading docs and scrolled over it)
@tyller_ not sure but the current database storage should be fine and if youre really worried about that then you can use multiple databases to sort of preserve as much storage as possible. Besides ur pushig it all to GS anyways so no worries about that
-
@jeffreyrb03-gmail yeah, but with uploading I’m thinking about all the logistics of not having two clients try uploading at the same time, and what if the client being used to upload data just closes the tab (when the warning when you try to leave the project page is added that won’t be an issue, unless request animation frame is paused by that prompt) I have many ideas and I think I have the willingness to try some rnrrr
<div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
</div> -
@jeffreyrb03-gmail yeah, but with uploading I’m thinking about all the logistics of not having two clients try uploading at the same time, and what if the client being used to upload data just closes the tab (when the warning when you try to leave the project page is added that won’t be an issue, unless request animation frame is paused by that prompt) I have many ideas and I think I have the willingness to try some rnrrr
@tyller_ yeah that stuff is always an issue with creaticode because there is no “server” or “backend” with projects, just client that can do server things using CC’s main backend. I don’t know how to fix that issue other than extensive testing and checking what will happen.
Edit: im referring to the thing about if someone closes the tab and data get s messed up#LLJW
<span style="color:white;background-image:linear-gradient(to right, lightblue, navy)">My name is Jeff</span> -
@tyller_ yeah that stuff is always an issue with creaticode because there is no “server” or “backend” with projects, just client that can do server things using CC’s main backend. I don’t know how to fix that issue other than extensive testing and checking what will happen.
Edit: im referring to the thing about if someone closes the tab and data get s messed up@jeffreyrb03-gmail yeah, with projects that require a server my idea is you just assign the oldest client (or if it’s a project with a lobby the host) to be the server and have some checks so if the host leaves the world then the project tries to assign a new host, the pop up when you try to close the page would make it a lot easier to have the client acting as the server “gracefully” transition the status of server or save data when they try to leave
<div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
</div> -
@jeffreyrb03-gmail yeah, with projects that require a server my idea is you just assign the oldest client (or if it’s a project with a lobby the host) to be the server and have some checks so if the host leaves the world then the project tries to assign a new host, the pop up when you try to close the page would make it a lot easier to have the client acting as the server “gracefully” transition the status of server or save data when they try to leave
@tyller_ I thought of this before but I’d have a computer always on that acts as the server but that’s a whole other issue and idk how to do it without buying a computer and making it run 24/7
#LLJW
<span style="color:white;background-image:linear-gradient(to right, lightblue, navy)">My name is Jeff</span> -
@tyller_ I thought of this before but I’d have a computer always on that acts as the server but that’s a whole other issue and idk how to do it without buying a computer and making it run 24/7
@jeffreyrb03-gmail okay so my current plan is to have it write to the sheet in a specific cell and use an extension in sheets to either copy the raw data (one cell for it all, using join with and some stuff to prevent the data from escaping, if you want to know what I mean then ask) to one cell, and have the user just read all the data and format it on the client, or I can have the user post data to a random place in a receiving sheet and the extension copy’s all the data that the client posted into the sheet
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login