electroly / sqlnotebook Goto Github PK

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:

1. The first column converts from text to alphanumeric. How do I prevent this?
2. The table seems to truncate at around 10% of the rows, not always in the same spot so I don't think there is something odd in the data.

Thoughts?

Thanks,

Craig

error importing from sqlserver

adocreate: incorrect sintax ners "ROWS"

This is a nice function from PostgreSQL

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

How do I import tab delimited files?

How could I use it on GNU-Linux distros? Any plan about it?

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.

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.

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.

Unable to import .xls, xlsx files from the menu using the file import option.

Throws error that .xlsx isnt supported.

The command to import the xlsx from the script window is working.

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.

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.

The table viewer has thinner columns than the same table does when viewed as a script (Convert to script).

I usually use shortcut to save notebook, If I press ctrl+s 2 times, there will be DC3 in scripts
I guess you control the menu item to not allow save multiple times, but shortcuts is not.

Renaming the table "AwardsPlayers" to "awardsplayers" results in the error: "there is already another table or index with this name: awardsplayers"

HttpListener seems to need admin rights in Windows 7 which aren't necessary in 10. Probably need to use a different web server library.

I don't like how the license smells.

Downloaded the msi installer.
When it runs there is no visual feedback.
Suggest to add a "Install Done" message box.

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.

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

In a machine with Windows 7, SP1, x64 throws the following error:
Missing "api-ms-win-core-winrt-l1-1-0.dll"

This obviates the need for our own REGEXP implementation and adds stuff we don't have.

Submitted in #46

Please try below code :

DECLARE @DaTa = SPLIT('AAA|BBB|CCC', '|', 1);
select @DaTa

Expecting the result as 'BBB' as per your documentation where we are getting 'System.Byte[]'

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.

Would you have plan to release?

confuse error message

The process cannot access the file 'C:\Users\brian\AppData\Local\Temp\SqlNotebookTemp\delete.lst' because it is being used by another process.

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.

No matter what I try, I can't get the console to do anything. Am I doing something wrong?

Putting the same commands in a script window and pressing f5 does work, however.

I have tables with the same name in various schemas, supporting schemas in the import MS SQL import dialog would allow a user to determine the correct table for the source.

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.

Seems to be taking from Internet Explorer color definitions.
Suggest would be better to use System colors as default.

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.

Is it possible to support 32bit win7 ?

Cannot connect to a SQL Azure database via Azure Active Directory authentication.

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?

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?

Hi team,

I am trying to open json file and getting below error.

The file type .json is not supported.

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.

Importing delimited files should allow specifying a custom delimiter, otherwise I have to preprocess delimited files into csv before importing.

ConsoleStates remaining even if Console is deleted, so also the used variables are available.

The text is still protected.

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!

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

This aspect of T-SQL was misinterpreted.

A nice to have would be to customise the grid fonts (Consolas, monospace, etc) and/or colours.