![]() ![]() You can change the code in any way you like, though if you make a query too broad it will fetch large amounts of data ) Press the Run button to run the following demos. Here’s a demo using the World Development Indicators dataset - a dataset with 6 tables and over 8 million rows (670 MiByte total). So I wrote a tool to be able to use a real SQL database in a statically hosted website! Hosting a static website is much easier than a "real" server - there’s many free and reliable options (like GitHub, GitLab Pages, Netlify, etc), and it scales to basically infinity without any effort. Then when I revisit it years later, I’m annoyed that it’s gone and curse myself for relying on an external service - or on myself caring over a longer period of time. In the past when I’ve used a backend server for these small side projects at some point some external API goes down or a key expires or I forget about the backend and stop paying for whatever VPS it was on. But if you want to use a database, you either need to write a backend (which you then need to host and maintain forever) or download the whole dataset into the browser (which is not so great when the dataset is more than 10MB). I don't know if any of this is helpful, but I thought I'd report it.I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. Stopping and restarting the server still doesn't save the account status in these tests. ![]() I log out with the 'guest' user and log back in (without the concurrent admin logged in) and THIS time, my guest is able to /money pay my admin, but gets the same errors as before when she tries to pay herself. My admin guy logs out while my guest guy is still logged in and the /money pay command reverts to causing the same error messages. I open another MC instance, log in with my admin user at the same time, and pay works just fine for both users. 01:47:25 at .dispatchCommand(CraftServer.java:176) 01:47:25 at .dispatch(SimpleCommandMap.java:77) I log into my server with another account, one which isn't mentioned in Permissions and should default to guest with:Īnytime that user tries to issue a /money pay command (/money stats and such work) to anyone (herself or my admin), the server returns: Okay so, I was able to actually produce some errors. 04:05:37 at .run(SourceFile:366)Īdditional information, quoted from Janb (via Bukkit forums) 04:05:37 at .dispatchCommand(CraftServer.java:176) 04:05:37 at .dispatch(SimpleCommandMap.java:77) When using a SQLite database, a NullPointerException is thrown when attempting to pay or grant money to an account that does not yet exist. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |