>>3391
>isn't the poshest db in terms of what you have to work with
It's worth noting that sqlite supports extensions so you can get slightly closer to bigquery-level stdlib with something like https://github.com/nalgeon/sqlean

That said, these should really be thought of as row-valued functions (which can be used in e.g. a SELECT clause to transform some value into another value) and table-valued functions (which can produce an entire table, perhaps lazily). They can be useful to avoid dropping down into code for such data-transformations, but but it wouldn't solve your particular issue.

It's not integrated yet, but I've been working on a prototype of the home page. I think for every other "tab", the contents will be pulled from a text file the owner edits manually. While this does require them to know a little html, it offers the most flexibility for them and the least amount of work for me.

>>3400
Looks good, and I like the feel of the board (although I personally prefer the cool blue of yotsuba v2 myself).

>>3401
>I personally prefer the cool blue of yotsuba v2 myself
Theming is fairly straightforward. Also made it more compact for functionality's sake.

I was going to post a few pictures on the steps of making fried rice, but the quality was so bad that it wasn't worth it. Here's one most of the way through. It's basically fried rice for people who don't want to put that much effort into it, I eat this just about every evening in one large portion, because I do not eat very much for the majority of the day. The thing that dictates taste most is how well the rice is made (how much water to use, how long to cook it). After this it's easy to be consistent. After you make the rice, make some eggs in a pan (I use 3 usually) and scramble them on about half way heat on the gas burner. You don't need to cook them completely just so that they're not runny because you still have to add rice etc and they will continue cooking. Then put all the rice in the pan and stir it up with the eggs. When it's all stirred add oil (any kind works, I have olive oil) what I do is put a little bit around the rim of what's in the pan. Then stir it up and add soy/tamari sauce. The amount of this used is the second thing that dictates taste, and if you use low salt or regular kind. I usually make 1.5 cups of dry rice, and based on what I measured today about 1/8 cup (not exact) of sauce works well. Then stir it and leave it till it browns rice a bit, then add vegetables. Sometimes I add green onion if I have it but I don't today. I usually just use a ton of broccoli. I get it frozen, with that you can just take it out of the freezer and put it in the pan frozen. A good way to gauge when its done is just to turn off the heat when the vegetables have thawed out completely. It's a pretty quick meal to make, and it tastes great at least I think so. The process is basically stir, wait 10 seconds, stir, etc. until it's done. You could probably very easily make better fried rice by looking it up a bit and putting some more things in, but far as I'm concerned it's 80% of the result for a fraction of the effort.

Post edited on 3rd Mar 2020, 7:55pm

Here's what I've been eating for breakfast lately. Pancake with whipped cream and instant coffee with milk.

The pancake recipe is as follows:
Dry: 1/2 cup (~60 g) flour, 1 Tbsp (~12 g) sugar, 1 tsp (~4 g) each of baking powder and spice mixture, a sprinkle of salt.
Wet: 1 Tbsp (~15 mL) oil (I've been using canola but any neutral oil works), 1 egg, 1/4 cup (60 mL) milk.
Mix dry with dry, wet with wet, then mix dry with wet. I cook it at a low heat, and when the top has bubbles all over it I flip it once. It takes maybe 10 minutes or less in total on the stove. I don't measure anything for it, but the batter should not be too runny. It should be somewhat thick.

For the whipped cream, I start by keeping a metal mixing bowl and whisk in the freezer overnight. I take it from the freezer and pour in 1-2 Tbsp (15-30 mL) of heavy whipping cream and lately 1 tsp (4 g) sugar. I then whisk the shit out of it, which takes about 3-5 minutes. I usually do the whisking while the pancake is on the stove and after I've washed the dishes.

>>3048
Homemade whipped cream is the best. Nice mug too.

It's my waifu's day soon, and I'd like to make a cake. Specifically, I want to make chocolate cake with a layer of sliced strawberries and pudding or something similar. It's my understanding that you're supposed to make the cake, stick it in the freezer or fridge to cool it down, then cut it in half to add the middle layer.
Does TC have any advice that may help me from fucking everything up?

whats your end goal?

>>3312
End goal? Maybe someday making Gensokyo. That's pretty ambitious, so for now, I'd be happy just making the 2hus. One step at a time.

Finally got around to going through a 3D modeling tutorial. It's pretty fun. Nowhere near as bad as I expected. It'll probably take me a bit to make anything good. Still, I can probably lean on modifying assets that already exist, though I'd prefer to do most things myself.
Well, with this first step, it feels significantly more viable. I'll probably jot down related ideas now.

>>3213
Thanks. This Sunday, I'm planning on asking on the irc if anybody is interested in trying to play a game. Don't really know how to get the ball rolling on this or what the best place would be.

Added a page to explain how to use the client since both people I tried it with found it confusing.
https://luciferspastime.neocities.org/using%20the%20client.html

>>3215
cant download anymore...

>>3379
The links on the front page still work for me
https://luciferspastime.neocities.org/
There's also the git repo
https://codeberg.org/vodahn/Lucifers_Pastime

>>3240
Check out https://neocities.org. As you might surmise, it's similar to geocities. So it's only for static content, but it should be good enough to get you started. And it's free~

I upload my work to YouTube on my seperate channel or my Artstation page.

Been thinking of making a Plillowfort account to dump art on.

>>3377
Almost forgot about this site, seems you still need to pay to access the open beta.

>>3335
here's the world map. those circles are the mountai s regions

>>3336
I don't need help. At best, someday I might put out a version for playtesting.
I already have it all in my head, I just need to put it together. Then maybe I'll try and sell it for a couple bucks. I'll end up making a cool $5 total and spend it all on an ice cream cone.

>>3339
but I want to make a video game with you ToT

>>3300
>>3298
> if you don't have anything but a phone
That's a terrible attitude. Your phone is more powerful that what they had in the 90s, and you can easily use it for general purpose programming. Even if it's not rooted, use termux or something which provides things like gcc and python compiled against ndk, or on ios use ish. Even if you disallow native apps entirely, you have the entire browser at your disposal, and you can use webasm within that to do something meaningful.

>>3301
>Your phone is more powerful that what they had in the 90s
Yes, but in other ways, it's worse than something from the 90s. As a platform, and hardware-wise.
>you can easily use it for general purpose programming
Assuming you have a compatible keyboard.

>>3301
Computers in the 90s had keyboards, real ones. They also had screens larger than your hand. So you could actually see what you're doing. Your device processing power means absolutely dick.
The only thing terrible here is the stuff being made by people who have no business making it.
You're talking about someone who clearly has little experience using imageboards and likely the internet itself, what experience they do have is using crappy mobile versions of every website they visit. They wouldn't know how to make a proper website because they've never seen one. They're too lazy to proof read their posts and fix spelling and/or grammar errors, They're unwilling to do their own research, They don't have the most basic tools or materials for the job. They're also likely unwilling to pay for a server if they're unwilling to fork out $60 for an old used laptop. what they do have is a tiny screen and a fake keyboard on a handicapped operating system. Their priorities are backwards to say the least. Before making their own site, they should do as the old saying goes and lurk more. Build experience, learn how things work, and for god's sake get a real keyboard at the very least.

This is the equivalent of someone who just bought a hammer begging construction workers to help him build a house. It would be funny if it wasn't so insulting. OP strolls in here acting like creating a imageboard/forum is as simple as running an app on his phone and my attitude is terrible? I'm being polite here compared to the average imageboard user, which he likely has never had the pleasure of dealing with and would rip his ass a new one with some creative language for posting something like this.

>>3304
>>3304
>Computers in the 90s had keyboards, real ones.
You can plug in a USB keyboard to your phone (with the appropriate usb to micro-usb adapter I guess). Or use a bluetooth keyboard.

>They also had screens larger than your hand. So you could actually see what you're doing
Fair, but this isn't a limiting factor. With how large phones are these days (and their resolution) you can still manage to work on things. I'm not saying developing on a phone is going to be a comfortable experience, but it can be done if you're willing to put in the effort to find creative workarounds.

The rest I do agree with, and if one is going to do software dev he should at least learn how to google rather than asking people for help.

But also I suggest making your game playable in either the VASSAL engine or Tabletop Simulator so you can playtest it's flow before committing to an idea.

>>3268
I tried using vassal but I donnt understand it at all and tabletop isn't in sale on steam. What do?

>>3269
Try harder.

>>3270
ok

>>3260
Did this person put their hand in the mouth of a singing ghost, and get a bump from the bite?

>>3261
ghost is listening to ghost music. human change music, after that they're shaking their body then both tewrking

Posting handwriting on the internet seems dangerous.

>>3220
I suddenly remembered this thread, thought it was a neat idea and wanted to post just to come and see a post vaguely claiming it seems dangerous.
Anyone have any idea why it would be dangerous?

>>3249
I can't think of a way it'd be _dangerous_, although I suppose in the worst case it might allow someone in the real-world to learn that you are a poster on TC, but they'd need to have another sample of your writing tied to your real-world identity to compare against. It might also allow someone to forge your writing, but unless that can be linked to a real-world identity it seems useless as well.

So in short I don't see how it could be dangerous, although that being said as a paranoid person I'd still hestiatae in terms of opsec to upload anything that could undeniably link with real-world identity.

>>3250
Oh right. I was thinking it was due to feeding algorithms and AI even more data.
Your concerns are more reasonable though, thanks.