0

It seems to be impossible to create a new SQLite data database entirely from scratch in IntelliJ idea or Datagrip.

here is what I do:

  1. From the database window, create a new SQLite database.
  2. The new database shows up in the database window.
  3. From the popup menu, you can only create another database.

here is what I tried to do: enter image description here

but nothing changes: enter image description here

what should I do to be able to create a new table?

humazed
  • 74,687
  • 32
  • 99
  • 138
  • Have you hit the little refresh button to see that the schema changes have taken place? – Makoto Apr 11 '16 at 03:44
  • I do but nothing change – humazed Apr 11 '16 at 03:47
  • I tried to reproduce that behavior, but when I execute an create table statement against an sqlite database file I see the data table immediately in may database tab. Which DataGrid version are you using? Did you really execute the ddl (sorry for that question)? Did you get an error message? – Peter Apr 11 '16 at 10:33
  • 1
    Hello, I am Max from JetBrains so I am here to help you. But it's not clear what you are doing. Can you please give more information? – moscas Apr 12 '16 at 08:30
  • Thanks, I figure it out, it was a silly mistake. – humazed Apr 13 '16 at 14:59

1 Answers1

2

It was a silly mistake by me. it was my first time using datagrip so I wasn't very familiar with it.

when I was trying to create a new database I was just From the database window, create a new SQLite database. and the press OK. this was creating .sqlite which is used to store SQL code, not a real database.

so the right way to do this is just to click the green + icon and create a new database file.enter image description here

humazed
  • 74,687
  • 32
  • 99
  • 138