Fetch Very Last Item From Base

[HanzCEO]

Hi, i like DetaBase

But i feel guilty and inefficient when i want to fetch the latest pushed item from Base.
I know i can fastforward until res.last is falsy but this thing is worrying me.

I think adding db.fetchLast wouldn't hurt.
What do you think guys?

[abdelhai]

hi, thanks!
in base, there's nothing called "first" and "last". you can optimize the items you are storing a bit and maybe use a datetime sorted key and look for a key that was created in the last x hours/minutes/etc and then narrow down the last on the last item. this should make queries efficient and fast.

[HanzCEO]

Thanks for the inspiration!

[fanfanmyid]

Hi, can you give me some example to do this?

[abdelhai]

check out this answer https://github.com/orgs/deta/discussions/344#discussioncomment-3263320