Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

setup issues #1

Open
KrasowskiMichal opened this issue Jul 27, 2023 · 0 comments
Open

setup issues #1

KrasowskiMichal opened this issue Jul 27, 2023 · 0 comments

Comments

@KrasowskiMichal
Copy link

Sadly, I was not able to start it up.
Leaving some feedback for a better tomorrow ;)

There are some details that could be described in terms of database setup.

  1. I tried planet-scale. It turns out by default secure connection is expected. I have added ?sslaccept=accept_invalid_certs to change that.
  2. Perhaps it is obvious but i replaced stars in the connection string with a password of the instance.
  3. I initialised tables as follows guessing a structure:

CREATE TABLE planetscale1.EmployeeSatisfaction (
age INT NOT NULL,
gender VARCHAR(50) NOT NULL,
happiness_value INT,
job_area VARCHAR(100),
job_title VARCHAR(100),
job_type VARCHAR(50),
employee_id VARCHAR(255) PRIMARY KEY NOT NULL
);
CREATE TABLE planetscale1.Purchases (
age INT,
gender VARCHAR(255),
location VARCHAR(255),
product_material VARCHAR(255),
product_name VARCHAR(255),
product_tag VARCHAR(255),
purchase_date DATE,
purchase_value DECIMAL(10,2),
user_id VARCHAR(255)
);

note: this is a guess and might be wrong.
Only then I was able to upload data with a script.

  1. Log on to localhost:3000, but unfortunately analysts are not generating anything.
    No verbose errors/traces in the console that is running the process.

I have no more time today, so leaving this as an issue.

PS.
This is VERY interesting use case, I would love to check it and develop to my needs. Thanks for sharing.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant