stormasm/ioxnotes

legacy folder of old dbnotes see link below for the new notes

To get up and running

iox
iox01
iox02

To add a second database to query

iox01nm iox02nm

To clear everything out and start over

cd
cd .influxdb_iox
rm -fr *

For more details see...

• Integrating with Nushell
• Readme
• env.example
• Legacy iox Readme
• InfluxDB 3.0: System Architecture
• Influx Data Model

Aliases

alias ioxg='cd ~/j/tmp06/influxdb_iox'

### Start up iox
alias iox='ioxg; ./target/debug/influxdb_iox'

### Write to iox
alias iox01='iox -vv write company_sensors test_fixtures/lineproto/metrics.lp --host http://localhost:8080'

### Read from or Query iox
alias iox02='iox query company_sensors "SELECT * FROM cpu LIMIT 10"'

### print iox Help
alias ioxh='ioxg; ./target/debug/influxdb_iox --help'

Testing

TEST_INTEGRATION=1 TEST_INFLUXDB_IOX_CATALOG_DSN=sqlite cargo test --test end_to_end

For more details on testing.

Documents of Interest

(to check out further in the future)

• debug.md

Historical Note

Start of new instructions in late summer 2023. I have not been using iox for awhile and we now have a local sqlite db. And postgresql is no longer required to get up and running. For more details see PR 7027.