Coaster
Coaster
PostsComments
DTDrizzle Team
Created by cosbgn on 3/25/2025 in #help
What does .all() do?
As far as I can tell, it won't change anything from the default and is just there for explicitness. This is the only comment from the drizzle team I can find on the topic: https://discord.com/channels/1043890932593987624/1120660739510779924/1121093480136048660
6 replies
DTDrizzle Team
Created by cosbgn on 3/25/2025 in #help
What does .all() do?
Hey, I belive .all() returns every record from the query, which is the default, but can be switched out for .get() to only return the first record. All is only available for SQLite as far as I can tell. Not sure what you are using but if it's not SQLite there should be no all available to you. 
const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .all();
const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .all();
returns: 
[
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
  },
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 1, ownerId: 1, content: 'Hello from post 1' }
  }
]
[
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
  },
  {
    users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
    posts_table: { id: 1, ownerId: 1, content: 'Hello from post 1' }
  }
]
whereas 
const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .get();
const postsJoin = await db
  .select()
  .from(usersTable)
  .leftJoin(postsTable, eq(postsTable.ownerId, usersTable.id))
  .get();
returns: 
{
  users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
  posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
}
{
  users_table: { id: 1, name: 'Bob', age: 1, email: '[email protected]' },
  posts_table: { id: 2, ownerId: 1, content: 'Hello form post 2' }
}
lmk if that makes sense
6 replies
DTDrizzle Team
Created by CyberCipher on 3/14/2025 in #help
How to run migrations in production environment?
Yeah it won't hurt anything to run it every time as long as you are not pushing unsafe migrations
12 replies
DTDrizzle Team
Created by CyberCipher on 3/14/2025 in #help
How to run migrations in production environment?
Yes
12 replies
DTDrizzle Team
Created by CyberCipher on 3/14/2025 in #help
How to run migrations in production environment?
Hey, check out this part of the docs: https://orm.drizzle.team/docs/migrations, most likely section 4 If you want Drizzle to manage migrations for you while keeping it a seperate command, running your code in migrate.ts before running the start command sees like a good option. You could set up your production start command to be tsx migrate.ts && <sveltekit start command> which would migrate the database using the generated migrations, and then run the svelte kit app. Let me know if that made sense
12 replies