|
||||||
Views:
8,953,433 |
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search | 03-29-24 09:38 AM |
||||
Guest: Register | Login |
0 users currently in msg db 'Computer Address',0xa | 1 guest | 1 bot |
Main - msg db 'Computer Address',0xa - ABΔ, or Delta, an OOP messageboard attempt |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 368/1016 EXP: 2165048 Next: 49049 Since: 01-02-12 Last post: 4357 days Last view: 4328 days |
You should still use a background in the mobile theme, AMOLED screens have great colour reproduction. Just don't make it too detailed.
Also, it does not make sense to me, that the font size is changed below a certain resolution. Be aware that tablet displays are up to 2560x1600 in just about 25 cm. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 310/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
Why would you bring up tablets when I've just emphasized this is for phones?
Also, it's not the resolution that triggers the change, it's orientation. Holding your phone in landscape orientation makes it wide -- like a desktop computer. For tangentially related fun, check out the Noxico screenshot diary in both orientations on a phone and compare it to the view on a desktop computer. |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 369/1016 EXP: 2165048 Next: 49049 Since: 01-02-12 Last post: 4357 days Last view: 4328 days |
Posted by KawaYou're right, on second thought, tablets have excellent zooming and high resolution. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 317/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
Folded the database into itself even more, removing the Last Post and Started By fields. Then I added them to the actual index page, including direct link ».
I'll update the rarchive when editpost is in. |
Arisotura |
| ||
Developer
pancakes Level: 83 Posts: 74/1868 EXP: 5395845 Next: 36376 Since: 01-05-12 From: France Last post: 655 days Last view: 194 days |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 346/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
It's really very simple. We I seriously haven't had to recalculate anything so far, and never will. Unlike in ABXD, which has a script for specifically that purpose. |
Arisotura |
| ||
Developer
pancakes Level: 83 Posts: 76/1868 EXP: 5395845 Next: 36376 Since: 01-05-12 From: France Last post: 655 days Last view: 194 days |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 348/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
Even so, I did say "roughly". Trade one thing for one other thing, but which is more taxing for the server: insert/update, which requires changing the table's files and various other kinds of bookkeeping, or a select subquery, which shouldn't make no change at all? And considering how much better the servers have gotten, does all of that even matter? |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 406/1016 EXP: 2165048 Next: 49049 Since: 01-02-12 Last post: 4357 days Last view: 4328 days |
I would say, keep the the code and the database as clean as possible, and conserve bandwidth. Server CPU's are really not an issue nowadays. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 381/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
That's basically what I'm doing already. Even the database tables' field names are adjusted for readability. |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 401/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
Post revisions
The post_text table right now: parent_post message revision where revision is coupled to posts.last_revision Suggested format: id parent_post message and remove posts.last_revision. WHAT? Grab the most recent revision for a post (say, #42) by subquery: ORDER BY id DESC LIMIT 0, 1
Grab revision N for the same like this: ORDER BY id ASC LIMIT N-1, 1
So basically grab revisions not by a "revision #" field, but by limit range. Example:
Final assembled query:
Instead of SELECT * FROM posts LEFT JOIN post_text ON post_text.parent_post = posts.id AND post_text.revision = posts.last_revision .
This is an actual thing, even though there's no "edit post" interface yet. |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 472/1016 EXP: 2165048 Next: 49049 Since: 01-02-12 Last post: 4357 days Last view: 4328 days |
Mobile view still needs background.
I suggest ABDX at 3x zoom. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 517/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
Needs, bro? I don't think it needs a background. |
Kiyoshi |
| ||
Normal User
HEY HEY HEY STAY OUTTA MAH SHED Level: 64 Posts: 486/1016 EXP: 2165048 Next: 49049 Since: 01-02-12 Last post: 4357 days Last view: 4328 days |
Posted by KawaMobile sites are meant to be compact, not boring. ____________________ I don't give a flying feather |
Kawa |
| ||
Retired Staff
Not okay Prophet of Celestia Level: 93 Posts: 533/2423 EXP: 7974583 Next: 78227 Since: 01-01-12 From: The Netherlands Last post: 2000 days Last view: 315 days |
It's allowed to be boring -- it's a work in progress.
Where "it" is Delta in general. |
Main - msg db 'Computer Address',0xa - ABΔ, or Delta, an OOP messageboard attempt |
Acmlmboard v2.5.5 (10/04/2020) © 2005-2024 Acmlm, Emuz, et al. |
MySQL - queries: 164, rows: 534/570, time: 0.058 seconds. |