# Spot the bug: React Native

> One snippet. Find the bug, or prove there isn't one.

Daily challenge: 2026-08-19 (UTC) · Mid-Level

```tsx
import * as SQLite from 'expo-sqlite'

const db = SQLite.openDatabaseSync('blog.db')

type Post = { id: number; title: string; author_id: number }

export async function loadPostsWithAuthors() {
  const posts = await db.getAllAsync<Post>('SELECT id, title, author_id FROM posts')
  const enriched = []
  for (const post of posts) {
    const author = await db.getFirstAsync(
      'SELECT name FROM users WHERE id = ?',
      post.author_id
    )
    enriched.push({ ...post, author })
  }
  return enriched
}
```

## Your verdict

- Security flaw
- Logic bug
- Code style
- No issue

One attempt per day. The answer shows up right after.

---

Source: SharpSkill (https://sharpskill.dev), tech interview preparation for your real stack.
HTML version of this page: https://sharpskill.dev/en/daily/react-native