Is there a better free database GUI to use?

There should be a company_id in the prices table

I use stock and company interchangeable. They are a entity listed on the stock exchange for which daily prices are recorded.

The problem is more making sure I would be structuring this in a way which might be considered best practice rather than cobbled together.

There is only one practice if you have two tables which you have described

m-1 relation

What about if I have the tables that also store analysis. Such as which stock has met some criteria to invest and on what date(s).

It depends on your goal itself. It will be implemented near the m-1 relative two tables

My goal is to setup tables which automatically identify a stock as meeting a single criteria. Then I can calculate various combinations of the criteria to look at investment strategy and performance.

Maybe it’s better to store timeseries data in another database, designed for this type.

That’s a good idea. I’ve not used a TSDB before but I was thinking of influxdb. Unless can you recommend one?

So store the prices in the TSDB and store the analysis criteria in a SQL relational db.

Yes, mix them. I can recommend InfluxDB it’s a good choice. Also take a look on VictoriaMetrics, it’s a young project from guys which are locating in Kyiv and it’s really a fast engine in this industry.

Also, there’s good project called Clickhouse DB from Russian company Yandex, but I’m not sure about financial data. They use this to store clicks and other integer-only data.

Clickhouse is mature at the moment.

I see. I’ll have a look at those thanks!

And in terms of learning more of best practice and how to structure databases for analytics can you or anyone else recommend a particular source: book, website, course etc.

Have a look at this project

https://github.com/alpacahq/marketstore

From this project you can gain important information about storing financial data

Thanks that looks exactly like my use case

You’re welcome

Is there a new way too structure an SQL Alchemy connection string from python to connect to mysql database.

I’ve got MySQL, Jupyter notebook and others in Docker compose but the normal connection string: user, pass, up, port etc doesn’t work. Say if up is 192.168.0.12 I always get error can’t connect to 127.0.0.0. it’s like no matter what I type is always trying to connect to a default address and won’t accept anything different. I’m currently using MySQL.connector in the format as described in the docs

Please show your connection string

engine = create_engine(‘mysql://root:root@ipaddr:port/dbname’)
https://docs.sqlalchemy.org/en/13/core/engines.html

I’ve tried the default library and a number of others with no luck.

I know how to make it. I asked for your

I don’t have my PC Infront of me. But from memory it was:

engine = create_engine(‘mysql://root:root@192.168.0.12:8080/stocks’)

Then the standard pandas pd.to_sql referring to the above connection. I can clarify in the evening

https://docs.sqlalchemy.org/en/13/core/engines.html

Usually MySQL runs on 3306 port

Ah I stupidly included my phpmyadmin port. I’ll try that tonight.

Is there a better free database GUI to use? I find phpmyadmin so bad.

PHPMyAdmin is the worst

Try official MySQL Workbench client or DBeaver

This is not mysql question

Thanks for the reminder to use the right port. I feel so silly.

try to use mysql workbench

I’ll give MySQL workbench a go I couldn’t find a Docker container or compose script for DBeaver

What ?

DBeaver in Docker ?

Yes as a Docker file or docker-compose file

Why?

Is it your faith that everything must be run in it’s own Doker?

No I just seem to clog up my system with installs of software when I’m trying it out and so it’s easier for me if I can run everything in Docker. If not available I will install locally to avoid phpmyadmin pains.

Any one give me idea what is fetch_status

mmm, mysql dont have fetch_status

Anyone give ME idea what “fetch status” is

Can we learn talend in 2 days?

What is the meaning of block nested loop

What is this “block nested loop”?
Explain your question in more details

I got this when I did explain on a query

So post the query, the plan, ddl, and all details you thins area reasonable, and then ask

Guys I want to study mysql . Anyone pls suggest from which book I should start

Thanks bro

I’ve also found lynda.com (now linkedin helpful)