Query builder bug: `inRandomOrder` method is not implemented

[michaelvcolianna]

In this commit last year, the inRandomOrder method is commented out.

The docs mention random ordering, but when trying to use the method, an error shows up in the console: TypeError: __vite_ssr_import_0__.DB.table(...).inRandomOrder is not a function

Code used:

const randomUser = await db.table('users')
  .inRandomOrder()
  .first();

[kiddyuchina]

Thanks for reporting this issue. You're right — the inRandomOrder method was removed in that commit because it wasn't possible to implement it in a consistent, testable way across different database engines.

For now, you can implement random ordering manually in your query. Here’s an example for SQLite (you can adjust based on your database):

const randomUser = await db.table('users')
  .orderByRaw('RANDOM()')
  .first();

For MySQL/MariaDB, you can use RAND() instead:

const randomUser = await db.table('users')
  .orderByRaw('RAND()')
  .first();

I’ve updated the documentation to reflect this change.