Firebase数据库查询：如何检索数组内指定键并排除非数组内键？

Got it, let's walk through how to query Firebase Realtime Database to grab exactly the keys you want (key1, key2, key4) without pulling everything down to your client first. No more fetching extra data like key3 just to filter it out later!

First, let's assume your database structure looks something like this (adjust the root node name to match yours):

{
  "myData": {
    "key1": { "value": "foo" },
    "key2": { "value": "bar" },
    "key3": { "value": "baz" },
    "key4": { "value": "qux" }
  }
}

1. Using Firebase Modular SDK (v9+) #

The modern modular SDK makes this straightforward with the in operator paired with orderByKey(). Here's how to write it:

import { getDatabase, ref, query, orderByKey, where, get } from "firebase/database";

// Initialize your database instance
const db = getDatabase();
// The array of keys you want to fetch
const targetKeys = ['key1', 'key2', 'key4'];

// Build the query to match only keys in your target array
const dataQuery = query(
  ref(db, 'myData'), // Point to your root node
  orderByKey(),
  where('$key', 'in', targetKeys)
);

// Execute the query and handle results
get(dataQuery)
  .then((snapshot) => {
    if (snapshot.exists()) {
      console.log('Fetched exactly what you need:', snapshot.val());
      // This will only return key1, key2, key4
    } else {
      console.log('None of the target keys exist in the database');
    }
  })
  .catch((error) => {
    console.error('Oops, something went wrong:', error);
  });

2. Using Firebase Namespaced SDK (v8 and Older) #

If you're still using the older namespaced syntax, the approach is similar—just with a slightly different structure. Note that the in operator was added in v8.10.0, so make sure your SDK is up to date:

// Initialize database (assuming you've already initialized Firebase)
const db = firebase.database();
const targetKeys = ['key1', 'key2', 'key4'];

// Create the query
const dataQuery = db.ref('myData')
  .orderByKey()
  .in(targetKeys);

// Fetch the data
dataQuery.once('value')
  .then((snapshot) => {
    console.log('Matching data:', snapshot.val());
  })
  .catch((error) => {
    console.error('Error fetching data:', error);
  });

Key Things to Keep in Mind #

• 10-key limit: Firebase Realtime Database restricts the in operator to a maximum of 10 keys per query. If your target array has more than 10 entries, you'll need to split it into chunks of 10, run separate queries, and combine the results on the client.
• Bandwidth savings: This approach is way more efficient than pulling all data client-side—you only download the nodes you actually need, which is a big win if your database node has lots of entries.
• Nested keys? Adjust the path: If your target keys are nested deeper in the database, just update the reference path in ref(db, 'your/nested/path') to point to the parent node of those keys.

内容的提问来源于stack exchange，提问作者newjsstu