Using Query

[ditorodev]

hola!

This project looks super interesting, I have been trying to use it on my project and even isolated, and have not been possible to make it work. It kept having the same error and the machine could not start :(

This is my Dockerfile(im using the epic stack)

# This file is moved to the root directory before building the image

# base node image
FROM node:20-bookworm-slim as base

# set for base and all layer that inherit from it
ENV NODE_ENV production

# Install openssl for Prisma
RUN apt-get update && apt-get install -y fuse3 openssl sqlite3 ca-certificates curl

# Install all node_modules, including dev dependencies
FROM base as deps

WORKDIR /myapp

ADD package.json package-lock.json .npmrc ./
RUN npm install --include=dev

# Setup production node_modules
FROM base as production-deps

WORKDIR /myapp

COPY --from=deps /myapp/node_modules /myapp/node_modules
ADD package.json package-lock.json .npmrc ./
RUN npm prune --omit=dev

# Build the app
FROM base as build

WORKDIR /myapp

COPY --from=deps /myapp/node_modules /myapp/node_modules

ADD prisma .
RUN npx prisma@5.5.2 generate

ADD . .

RUN npm run build

# Finally, build the production image with minimal footprint
FROM base

ENV FLY="true"
ENV LITEFS_DIR="/litefs/data"
ENV DATABASE_FILENAME="sqlite.db"
ENV DATABASE_PATH="$LITEFS_DIR/$DATABASE_FILENAME"
ENV DATABASE_URL="file:$DATABASE_PATH"
ENV CACHE_DATABASE_FILENAME="cache.db"
ENV CACHE_DATABASE_PATH="/$LITEFS_DIR/$CACHE_DATABASE_FILENAME"
ENV INTERNAL_PORT="8080"
ENV PORT="8081"
ENV NODE_ENV="production"

# add shortcut for connecting to database CLI
RUN echo "#!/bin/sh\nset -x\nsqlite3 \$DATABASE_URL" > /usr/local/bin/database-cli && chmod +x /usr/local/bin/database-cli

WORKDIR /myapp

COPY --from=production-deps /myapp/node_modules /myapp/node_modules
COPY --from=build /myapp/node_modules/.prisma /myapp/node_modules/.prisma

COPY --from=build /myapp/server-build /myapp/server-build
COPY --from=build /myapp/build /myapp/build
COPY --from=build /myapp/public /myapp/public
COPY --from=build /myapp/package.json /myapp/package.json
COPY --from=build /myapp/prisma /myapp/prisma
COPY --from=build /myapp/app/components/ui/icons /myapp/app/components/ui/icons

ADD . .

# prepare Query Server
RUN curl --proto '=https' --tlsv1.2 -LsSf https://github.com/gc-victor/query/releases/latest/download/query-server-installer.sh | sh
RUN chmod 777 other/process.sh
ENV QUERY_SERVER_PORT="3000"
ENV QUERY_SERVER_PROXY="true"
ENV QUERY_SERVER_PROXY_PORT="$PORT"
ENV QUERY_SERVER_DBS_PATH="$LITEFS_DIR"

# prepare for litefs
COPY --from=flyio/litefs:0.5.8 /usr/local/bin/litefs /usr/local/bin/litefs
ADD other/litefs.yml /etc/litefs.yml
RUN mkdir -p /data ${LITEFS_DIR}

CMD ["litefs", "mount"]

The Error:

[gc-victor]

Hola @ditorodev! The logs show that Query is running correctly. The error looks like it is because it can't connect to the application. It would be helpful to see the logs when Query and the app are executed. There may be an error related.

[gc-victor]

I have moved my reply to this specific comment to this discussion page #96 to make it more consistent as I update it.

[ditorodev]

Heres the error im getting

[ditorodev]

So, in theory I can use query to build an admin panel too? But overall Query is more similar to remote-base than to anything else
I really like the concept altho seeing it in the integrations with epic stack gave me a totally different message, I guess with epic stack it serves a purpose of replacing a bit of the stack (the ORM) for Query

[gc-victor]

It is an esbuild error, not "related" to Query. It could be an issue with the templates, but I have tested it, and it looks like it works properly.

• Could you confirm that the file "@/config/shared/test.constants" exists?
• Do you have the latest version of query and query-server?
• Do you have the latest version of query-app?

[gc-victor]

So, in theory I can use query to build an admin panel too?

Yes, you can do it.

I guess with epic stack it serves a purpose of replacing a bit of the stack (the ORM) for Query

Not really. In the case of the epic stack, it helps connect to your remote databases, but not as ORM, providing all the Query features on top of the epic stack.

[gc-victor]

If you want to try it out, I recommend using query-app. You can use it locally, so it's easy to experiment with.

[ditorodev]

@gc-victor Regarding query-minimal it still seems to not be working? All auth was a success but when I curl the server it gives 404, maybe thats intended

[gc-victor]

I guess that you have forgotten to execute query function.

[ditorodev]

That worked! Pretty coool