4 ms·

I used to use SQL Server on a PC to deal with tables over 1 million rows. I'm on a Mac now... can I use SQL Lite? What is my best option? I am not a coder, I ju

I used to use SQL Server on a PC to deal with tables over 1 million rows. I'm on a Mac now... can I use SQL Lite? What is my best option? I am not a coder, I just know enough how to query SQL databases.

dav43 4y ago
A Million rows will be easy.
jll29 4y ago
The Mac OS download is also available from https://www.sqlite.org/download.html https://www.sqlite.org/download.html - and in any case SQLite is a single-file C program, so you could easily compile your own (but no need for the Mac).
squinteyedrogue 4y ago
Check out: https://sqlitebrowser.org/ https://sqlitebrowser.org/ You may also need the SQLite command-line tools from the SQLite website; https://www.sqlite.org/download.html https://www.sqlite.org/download.html Are you coming from using SQL Server Management Studio on a PC? If yes, you may be better off using something like PostgreSQL on Mac OS X, and a PostgreSQL GUI browser tool, because it may be harder to use SQLite in this situation as you don't have the benefit of using a computer language to make up for the datatypes that SQLite does not have. For example SQLite does not have a DateTime datatype. If you need to do a lot of date/time field manipulation in SQLite, this can be made easier when using a programming language like C#, because you can use a SQLite integer datatype to store the DateTime data, and then convert the integer to a C# DateTime datatype and do the DateTime manipulation in C#. But if you aren't a coder, then this option isn't available to you, and you will have to have other ways to manipulate DateTime data in SQLite like using the string datatype to store the date time values and then use corresponding SQL queries to handle the "DateTime stored as a string" situation. (Maybe I've over-explained here. Sorry) Here a PostgreSQL Mac OS X GUI browser download page: https://www.pgadmin.org/download/pgadmin-4-macos/ https://www.pgadmin.org/download/pgadmin-4-macos/

dav43 4y ago

A Million rows will be easy.

jll29 4y ago

The Mac OS download is also available from https://www.sqlite.org/download.html https://www.sqlite.org/download.html - and in any case SQLite is a single-file C program, so you could easily compile your own (but no need for the Mac).

squinteyedrogue 4y ago

Check out: https://sqlitebrowser.org/ https://sqlitebrowser.org/ You may also need the SQLite command-line tools from the SQLite website; https://www.sqlite.org/download.html https://www.sqlite.org/download.html Are you coming from using SQL Server Management Studio on a PC? If yes, you may be better off using something like PostgreSQL on Mac OS X, and a PostgreSQL GUI browser tool, because it may be harder to use SQLite in this situation as you don't have the benefit of using a computer language to make up for the datatypes that SQLite does not have. For example SQLite does not have a DateTime datatype. If you need to do a lot of date/time field manipulation in SQLite, this can be made easier when using a programming language like C#, because you can use a SQLite integer datatype to store the DateTime data, and then convert the integer to a C# DateTime datatype and do the DateTime manipulation in C#. But if you aren't a coder, then this option isn't available to you, and you will have to have other ways to manipulate DateTime data in SQLite like using the string datatype to store the date time values and then use corresponding SQL queries to handle the "DateTime stored as a string" situation. (Maybe I've over-explained here. Sorry) Here a PostgreSQL Mac OS X GUI browser download page: https://www.pgadmin.org/download/pgadmin-4-macos/ https://www.pgadmin.org/download/pgadmin-4-macos/