Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,952,143
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-28-24 10:14 AM
Guest: Register | Login

0 users currently in msg db 'Computer Address',0xa | 2 bots

Main - msg db 'Computer Address',0xa - ABΔ, or Delta, an OOP messageboard attempt
Next newer thread | Next older thread

Pages: 1 2

Kiyoshi
Posted on 01-30-12 07:43 PM Link | ID: 4401
Normal User
HEY HEY HEY STAY OUTTA MAH SHED
Level: 64


Posts: 368/1016
EXP: 2164812
Next: 49285

Since: 01-02-12

Last post: 4356 days
Last view: 4327 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
Posted on 01-30-12 07:52 PM Link | ID: 4403
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 310/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 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
Posted on 01-30-12 08:01 PM Link | ID: 4404
Normal User
HEY HEY HEY STAY OUTTA MAH SHED
Level: 64


Posts: 369/1016
EXP: 2164812
Next: 49285

Since: 01-02-12

Last post: 4356 days
Last view: 4327 days
Posted by Kawa
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.
You're right, on second thought, tablets have excellent zooming and high resolution.

____________________
I don't give a flying feather

Kawa
Posted on 01-31-12 05:51 PM Link | ID: 4582
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 317/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 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
Posted on 02-01-12 05:26 PM Link | ID: 4693
Developer
pancakes
Level: 83


Posts: 74/1868
EXP: 5395256
Next: 36965

Since: 01-05-12
From: France

Last post: 654 days
Last view: 193 days
Wouldn't such a change cause more load to MySQL by requiring it to parse subqueries select stuff from more tables?

However now, no more stuff like 'moving a thread doesn't update the lastpost links'.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kawa
Posted on 02-01-12 05:30 PM Link | ID: 4694
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 346/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
It's really very simple. We kill the Batman trade several separate update queries for several select subqueries. It roughly evens out, and we lose the risk of update anomalies.

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
Posted on 02-01-12 05:35 PM Link | ID: 4697
Developer
pancakes
Level: 83


Posts: 76/1868
EXP: 5395256
Next: 36965

Since: 01-05-12
From: France

Last post: 654 days
Last view: 193 days
Yes. Except that select subqueries are run on every index/forum view. Update queries are only run when you post, move a thread, or perform another action. Those happen less frequently than index/forum views.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Kawa
Posted on 02-01-12 05:39 PM Link | ID: 4698
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 348/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 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
Posted on 02-01-12 09:05 PM Link | ID: 4791
Normal User
HEY HEY HEY STAY OUTTA MAH SHED
Level: 64


Posts: 406/1016
EXP: 2164812
Next: 49285

Since: 01-02-12

Last post: 4356 days
Last view: 4327 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
Posted on 02-02-12 04:14 PM Link | ID: 4878
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 381/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
That's basically what I'm doing already. Even the database tables' field names are adjusted for readability.


Kawa
Posted on 02-03-12 04:15 PM Link | ID: 5033
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 401/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 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:
id parent_post message
66 41 Well, I don't know.
67 42 Your mother sucks cock in Hell!
68 42 Your mother is a classy lady!
69 42 (Mod note: there was an insult here at first)

SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id DESC LIMIT 0, 1
--> (Mod note: there was an insult here at first)

-- request revision #1 (original), so N = 1 0, 1
SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id ASC LIMIT (N-1), 1
--> Your mother sucks cock in Hell!
-- Note the ascending sort order.

-- request revision #2 1, 1
SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id ASC LIMIT (N-1), 1
--> Your mother is a classy lady!

-- request revision #3 (most recent) 2, 1
SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id ASC LIMIT (N-1), 1
--> (Mod note: there was an insult here at first)
Could probably simplify a little bit if you consider revision 0 to be the original, and not refer to it as a revision at all.

Final assembled query:
SELECT
posts.*,
(SELECT message FROM post_text WHERE parent_post = posts.id ORDER BY id DESC LIMIT 0, 1) message,
(SELECT COUNT(*)-1 FROM post_text WHERE parent_post = post.id) revision
FROM posts
WHERE whatever

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
Posted on 02-06-12 12:07 AM Link | ID: 5466
Normal User
HEY HEY HEY STAY OUTTA MAH SHED
Level: 64


Posts: 472/1016
EXP: 2164812
Next: 49285

Since: 01-02-12

Last post: 4356 days
Last view: 4327 days
Mobile view still needs background.
I suggest ABDX at 3x zoom.

____________________
I don't give a flying feather

Kawa
Posted on 02-06-12 04:26 PM Link | ID: 5552
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 517/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
Needs, bro? I don't think it needs a background.


Kiyoshi
Posted on 02-06-12 05:27 PM Link | ID: 5603
Normal User
HEY HEY HEY STAY OUTTA MAH SHED
Level: 64


Posts: 486/1016
EXP: 2164812
Next: 49285

Since: 01-02-12

Last post: 4356 days
Last view: 4327 days
Posted by Kawa
Needs, bro? I don't think it needs a background.
Mobile sites are meant to be compact, not boring.

____________________
I don't give a flying feather

Kawa
Posted on 02-06-12 05:29 PM Link | ID: 5605
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 533/2423
EXP: 7973714
Next: 79096

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
It's allowed to be boring -- it's a work in progress.

Where "it" is Delta in general.

Pages: 1 2


Next newer thread | Next older thread
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.

Page rendered in 0.077 seconds. (822KB of memory used)
MySQL - queries: 160, rows: 532/567, time: 0.059 seconds.