DB15 stock beta 엑셀 참고 : Rfit select var_pop(rt) from ( select dd, (cls-pre_cls)/pre_cls as rt FROM ( select dd, cls, lag(cls) over (order by dd) pre_cls from k2i where dd between '2024/04/05' and '2025/04/18' ) where rt is not null);select var_pop(rt) from ( select dd, (cls-pre_cls)/pre_cls as rt FROM ( select dd, cls, lag(cls) over (order by dd) pre_cls from kos where dd between '2024/04/05' and '20.. 2025. 4. 20. duckdb extensions first , download the extensions from s3 examplehttp://extensions.duckdb.org/v1.2.2/windows_amd64/ui.duckdb_extension.gz install the extension. D> INSTALL 'path/to/httpfs.duckdb_extension'; loadD>LOAD 'path/to/httpfs.duckdb_extension'; Currenly the ui extension is not working perfectly, it is not really support offline installation. 2025. 4. 10. postgresql # postgresql 실행$ sudo service postgresql start# postgresql 상태 확인$ sudo service postgresql status# postgresql 종료$ sudo service postgresql stop PostgreSQL 기본 마스터 계정인 [postgres]로 접속$ sudo -i -u postgres$ psql # if needed to changepostgres=# alter user postgres with password '1234'; #testshin id createpostgres=# create user testadmin password 'xxx' superuser;postgres=# \du # create testdbpostgres=.. 2025. 4. 5. oracle free 23ai with vscode 어찌어찌...연결까지..oracle linux 9document 대로 따라해봄... tns까지 잘되네요. (oracle 계정) 리스너체크# systemctl start oracle-free-23ai$ cd $ORACLE_HOME/bin$ lsnrctl status $ sqlplus / as sysdbaSQL> SHUTDOWN IMMEDIATE SQL> STARTUPSQL> ALTER PLUGGABLE DATABASE ALL OPEN; 2025. 3. 25. useful commands duckdb databasefilenameuse .help >duckdb -uiD call start_ui();D .promptD .excel D .exit 2025. 3. 24. big csv file first create a table in duckdb.then> copy table_name from 'csv_file'it's fast! 2025. 3. 1. 이전 1 2 3 다음
