What is nameIndex?

In the docs we have this example:

export const countries = pgTable('countries', {
  id: serial('id').primaryKey(),
  name: varchar('name', { length: 256 }),
}, (countries) => {
  return {
    nameIndex: uniqueIndex('name_idx').on(countries.name),
  }
});

export const countries = pgTable('countries', {
  id: serial('id').primaryKey(),
  name: varchar('name', { length: 256 }),
}, (countries) => {
  return {
    nameIndex: uniqueIndex('name_idx').on(countries.name),
  }
});

What does

nameIndex

nameIndex

mean here? Is it a random text or it actually means something?

Also, let's say we have another column called

chineseName

chineseName

for example. If an app can search using a where statement with the

name

name

columns and, on another query, use a where clause with the

chineseName

chineseName

, how should we treat indices?

Thank you

Drizzle Team•3y ago

Nelson Sousa

What is nameIndex?

In the docs we have this example:

export const countries = pgTable('countries', {
  id: serial('id').primaryKey(),
  name: varchar('name', { length: 256 }),
}, (countries) => {
  return {
    nameIndex: uniqueIndex('name_idx').on(countries.name),
  }
});

export const countries = pgTable('countries', {
  id: serial('id').primaryKey(),
  name: varchar('name', { length: 256 }),
}, (countries) => {
  return {
    nameIndex: uniqueIndex('name_idx').on(countries.name),
  }
});

What does

nameIndex

nameIndex

mean here? Is it a random text or it actually means something?

Also, let's say we have another column called

chineseName

chineseName

for example. If an app can search using a where statement with the

name

name

columns and, on another query, use a where clause with the

chineseName

chineseName

, how should we treat indices?

Thank you

What is nameIndex?

Similar Threads

What is nameIndex?

Similar Threads

Similar Threads

Similar Threads