electroly / sqlnotebook Goto Github PK
View Code? Open in Web Editor NEWCasual data exploration in SQL
Home Page: https://sqlnotebook.com
License: MIT License
Casual data exploration in SQL
Home Page: https://sqlnotebook.com
License: MIT License
Would you have plan to release?
I'm trying to export some data to text files:
Declare $TablesCount = (select count(name) from sqlite_master where type='table')
Declare $TableName
Declare $FileName
For $counter = 0 To $TablesCount-1
Begin
Set $TableName = (Select name From sqlite_master Where type='table' Limit 1 Offset $Counter)
Set $FileName = printf(D:\Data\Clientlists\SW - %s.txt', $TableName)
Print printf('Exporting names from %s to %s', $TableName, $FileName)
EXPORT TEXT $FileName FROM ( SELECT Name FROM $TableName )
End
Some hints to get it working? Is there a better way to do so?
Copying table from console output to notes is becoming invalid over a period of time when the underlying data changes.
So, it would be good in notes if we add a custom SQL widget and provide custom SQL query (only allowing select query from table or view is enough) then notes should get updated dynamically (maybe on manual refresh because dynamic refresh might need more resources).
In this way, this notebook will become a tough competitor for the Jupyter SQL notebook. Hatz off @electroly :-) For this awesome tool.
First off, many thanks for the wonderful tool. Next, unless I am missing something blindingly obvious it appears that there is no way to print a notebook page or to convert it to a pdf. Is this something that will be on roadmap or the only way to share a notebook I create is for another person to read it through sqlnotebook which would require installing it and is not always an option for some recipients working in restricted environments.
When trying to connect to our SQL server instance, using windows authentication, I get the error on first attempt:
The conncetion to Microsoft SQL server failed.
Invalid object name 'information_schema.tables'
I can relate the error directly to our sql server environment being case sensitive, in which the valid expression should use 'INFORMATION_SCHEMA.TABLES', instead.
Nice for version 1.1.0 which includes the load_extension support.
I try it and the result well
Another bug while try the window function.
Add the script with window function And it show "Not a statement.
"
I try with DB Browser for SQLite and the execution of the sql statement is OK.
What is the problem of sqlnotebook, cause the CTE function is native within sqlite?
We should prevent the user from arrowing left from their command into the prompt and before. They should have to use the mouse to click in the backlog in order to move the cursor there. Also we should prevent the user from arrowing right into the newline after the prompt.
This obviates the need for our own REGEXP implementation and adds stuff we don't have.
Cannot connect to a SQL Azure database via Azure Active Directory authentication.
error importing from sqlserver
adocreate: incorrect sintax ners "ROWS"
In a machine with Windows 7, SP1, x64 throws the following error:
Missing "api-ms-win-core-winrt-l1-1-0.dll"
This is a nice function from PostgreSQL
The text is still protected.
The table viewer has thinner columns than the same table does when viewed as a script (Convert to script).
Importing data from a view causes a select query with a TABLESAMPLE clause to be run against that view which causes the following error:
The Import Failed
AdoCreate: The TABLESAMPLE clause can only be used with local tables
How do I import tab delimited files?
HttpListener seems to need admin rights in Windows 7 which aren't necessary in 10. Probably need to use a different web server library.
This aspect of T-SQL was misinterpreted.
I have a txt file with 9M rows. I want to import it, group by zip code and then export it to csv with the 38K rows that remain. Everything works as desired until I try to export. Two things seem to happen:
Thoughts?
Thanks,
Craig
Currently variables can only hold single scalar values or array.
Set $val = (FROM * FROM Mytable)
dosn't work.
Set $val = (SELECT name FROM MyTable)
only uncludes the first found value.
Make variables able to hold table-like data, for example:
Set $data = (Select name, email From Users Where status='online') As table
For Each $data As $Row
Begin
Print printf('User: %s \tEmail: %s', $Row.name, $Row.email)
End
(I now, For Each
is currently not available)
Or let variables pointing to tables, eventually temp tables. So you can create a temp table of a (Select * From Blah)
Statement and let the variable pointing to this table.
As the title says I'm unable to save Notebooks due to the error "Object reference not set to an instance of an object.". This happens after hitting Save or Save as... and selecting a save location.
It's rather unfortunate, as I lost all my progress in creation of a notebook. I was able to save Notebooks as long as there were only tables in them I believe, but I am not 100% sure about that.
EDIT: I tried 1.1, 1.2 and 1.2 portable, the error is the same for all of these. I am running a Windows 10 PC.
Submitted in #46
A nice to have would be to customise the grid fonts (Consolas, monospace, etc) and/or colours.
Seems to be taking from Internet Explorer color definitions.
Suggest would be better to use System colors as default.
Is it possible to support 32bit win7 ?
I don't like how the license smells.
ConsoleStates remaining even if Console is deleted, so also the used variables are available.
What a wonderful work of sqlnotebook, just like python notebook
May ask for some request?
(1)sqlite load_extension
When I want to load extension for additional function, I cannot use load_extension sqlite function for statistic calculation that Anton Zhiyanov gather and compile.
https://github.com/nalgeon/sqlean
(2)Markdown Support for text block
(3)May be plot function in the future
Thanks!
When executing a join where table aliased as "a" is a local table and the table aliased as "b" is a remote SQL Server 2008 R2 table, an error is displayed:
SQL logic error or missing database
However, when the remote table is deleted and them re-imported as a local table, the query executes successfully.
The query syntax did not change, only the table import method changed.
select a.pro_number from ceva_csvfile a inner join ceva_cisdata b on a.pro_number = b.pro_number;
Also, when the table was a remote table, I double checked that the table was in fact accessible, by double clicking the table name in the left pane of SQLNotebook (under tables heading) in order to view the data.
Importing delimited files should allow specifying a custom delimiter, otherwise I have to preprocess delimited files into csv before importing.
Hi,
I downloaded your latest version of SQLnotebook and my installation of McAfee Antivirus scanner detected a virus within the package. I used the link provided on your web site and it was the portable version which I was downloading.
Hope this helps.
Downloaded the msi installer.
When it runs there is no visual feedback.
Suggest to add a "Install Done" message box.
It would helpful if i can add a link to a script or a console output (with line?) so i can navigate from my notes directly to it.
When using the menu option Import > From File.... and then choose an XLS or XLSX file the dialog "XLS import not supported" is displayed.
When using the import statement IMPORT XLS 'myfilename.xls' INTO tbl1 it works as expected.
Almost all the csv files I see in practise use tab or semicolon as delimiter. Maybe this is because in Europe the comma is used for decimal separator (as opposed to USA).
For csv datasets, the file import should at least support and detect comma (,) semicolon (;) and tab (\t) imho
It would be great if the datatype of multiple columns can be changed in bulk instead of clicking on each column and changing the datatype when importing csv files for that becomes very tedious with tables of many columns
The process cannot access the file 'C:\Users\brian\AppData\Local\Temp\SqlNotebookTemp\delete.lst' because it is being used by another process.
How could I use it on GNU-Linux distros? Any plan about it?
Let the user define script that would be run at certain events, eg. OnNotebookOpen or OnCreateNewNote, etc.
For me, i would use is to drop/clear some tables and refill it with csv data from network shares.
Script used for events should be marked, so the user don't delete them by mistake.
Renaming the table "AwardsPlayers" to "awardsplayers" results in the error: "there is already another table or index with this name: awardsplayers"
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.